By using this site, you agree to our Privacy Policy and our Terms of Use. Close

I really need help with an IF function. It's driving me nuts. The question is:

Perform a query to deduct a ten percent discount on total payments made by persons who made bookings on the Asian tour. Name this query FurtherDiscount.  

So I made a query with the columns: Name, Total Payment, Tour Specified

It has 4 tours: Asian, European, African, Caribbean

What I want to do is make an if function in my query that says: If Tour Specified=Asian then multiply the Total Payment field by 90%

Damn, can someone help me? Your help would be greatly appreciated!



3DS Friend Code: 0533 - 6146 - 0418
PSN ID: atylerman5