Can anyone who has experience in Microsoft Access help me?

[GdaTyler]

NiKKoM said:

GdaTyler said:

NiKKoM said:

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

Thanks, now it's making some progress, but I have a big problem. Strangely all fields associated with Asian have not been included. Damn you Microsoft! 

could you make a screenshot of the code you have right now? use tinypic or something similiar to upload a pic and post it here

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