Can anyone who has experience in Microsoft Access help me?

[NiKKoM]

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