Can anyone who has experience in Microsoft Access help me?

[GdaTyler]

NiKKoM said:

GdaTyler said:

NiKKoM said:

GdaTyler said:

NiKKoM said:

GdaTyler said:

Actually, I've found out what's wrong. If I multiply the field by anything other than 1 it doesn't show. Any solutions?

I'm actually at home where i don't have a PC.. (Mac only) so I'm winging this from memory..

did you place the iif statement in the Criteria row on the query design view? Delete that. Instead, you need to make the Iif statement its own field in query.

It then tells me enter parameter value. >:(

click cancel and check your rows and columns somewhere there should be a [identifier] or something like that popped up somewhere

nope don't see it. :(

Strange.. what does the dialog popup say? Enter parameter value [SomeIdentifier]?

It said the name of the column. :(

Wait, should I make a field called discount and multiply two fields together as a workaround? is it possible?