Using the iif statement

[Brien]

Working on a query were I have to show that if the monthly fee is greater than $35 to multiply that by 15% to make it a discounted enrollment fee, and if it is less than $35 to show no change but I am having issues. My syntax is ReEnrollmentfee:IIF([Monthlyfee]=">35", *0.15, 0) what is wrong with this syntax?

[pbaldy]

Try

IIF([Monthlyfee]>35, 0.15, 0)

[John_G]

Hi -

Assuming that you want to discount the re-enrollment fee by 15% if the monthly fee is over $35, try this:

ReEnrollmentfee:IIF([Monthlyfee]>35, [Monthlyfee]*0.85, [Monthlyfee])

John

[Brien]

Thank you John, it worked perfectly.

Hi -

Assuming that you want to discount the re-enrollment fee by 15% if the monthly fee is over $35, try this:

ReEnrollmentfee:IIF([Monthlyfee]>35, [Monthlyfee]*0.85, [Monthlyfee])

John

[Brien]

Thank you all for your help I learned something new today and it is a blessing thanks again

Brien