I'm making a database of a gym booking system. In the Booking table I have a field called Booking pass type, which the user can select. They contain like a Bronze Pass, Silver pass and so on. I need to create a query that basically makes a price for each of the different values of the booking pass type. Like I would need it to calculate a bronze pass, silver pass, gold pass and a One day pass. I know how to create a query to show a price of one type of booking pass type, but I'd like to know hot to do a IIF statement with 4 parameters so I can use all the booking pass types and make all the prices for it in one IIF statement. Here is one of the queries I made:
Expr2: IIf([Booking Pass Type]="Bronze",20)
Could any one enlighten me on how to do this? Your help is appreciated.
Expr2: IIf([Booking Pass Type]="Bronze",20)
Could any one enlighten me on how to do this? Your help is appreciated.