Welcome to WebmasterWorld Guest from 220.127.116.11
Forum Moderators: open
In the expression builder I get:
This works fine. However, some booking dates will be per person which is indicated by a yes/no box in the booking dates table. So my question is how to put a an if /else statement into the query like:
MinPrice: If tblPrices.PricePerPerson= True do this calculation else do this one.
Hope this makes sense.