Can anyone who has experience in Microsoft Access help me?

[GdaTyler]

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

Everything is alright except for the fact that I can't multiply anything by a number other than 1. For example if I put 2 or a decimal, 0.9 everything comes up blank. I even formatted total payment as a number in design view. Wtf is this crap, lol.