Well, I got a IIF statement working on how to solve the price of a booking system I do. Well now I have a field in a Booking table called service. In service the user can pick a Masseur or personal trainer. How would I create a query that say adds a price to the current price if a service is picked. Remember the service field is a drop down list. Here is my current query:
Expr1: IIf([Service]="Personal Trainer",Format([Prices]+6))
But that doesn't work. Help please? ;-)
Expr1: IIf([Service]="Personal Trainer",Format([Prices]+6))
But that doesn't work. Help please? ;-)