Can anyone who has experience in Microsoft Access help me?

[GdaTyler]

NiKKoM said:

GdaTyler said:

NiKKoM said:

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.

so when it's *1 the correct value (in numbers) is displayed? but not with 0.9 hmmm try something like

iif ([Tour specified]="asian", [discount], [total payment]*1)

and then add "discount" calculated field with [total payment]*.9

FINALLY!!! THANKS SO MUCH!!!!!!! I THANK YOU A LOT!!! Finally it's over.