Calculate Discount

[ryansox]

I am trying to create a discount column in a report that uses information on the amount paid column. If amount paid is $500 or more there is a 3% discount and if amount paid is under $500 there is a 1% discount. I can't seem to figure out how to do this.

Any Help,



Thanks

[June7]

Expression in query or textbox:

[Amount] * IIf([Amount]>=500, 0.03, 0.01)

[ryansox]

Expression in query or textbox:

[Amount] * IIf([Amount]>=500, 0.03, 0.01)

Thank you so much.