Selective/if fields

[mentaljedi]

I have a query that has the follwing fields:

Gross Payment :Currancy
Tax Discount: Boolean (Yes/No)

I want to create a new field called Tax Deducted that if the tax discount is no, the Tax deducted = Gross Payment * (22/100) but if tax discount is yes, then Tax Deducted = 0.

I'm not sure if i'm supposed to do this in a query or in a report but that's what i need to do. I ask if anyone can tell me what i need to do so that i end up with something like this:

Person A £29000 Yes 0
Person B £10000 No 2200

 

[Jon K]

In query Design View of your query, put the following in the Field: row of a new column.

Tax Deducted : IIf([Tax Discount], 0, [Gross Payment]*22/100)
.

 

[mentaljedi]

Thanks, it works for me!