how to build a function in access

[AmandaMc]

I am doing my sba for school and I am having difficulties putting a function to calculate: An exam grade >=80% will recieve a discount of 5% off exam processing fee, in a table in access.



I used this formula =IIf("Exam"=">=70%","5% dicount of exam processing fee") but nothing happened with the figures.
The file could not be attached but, I could email the document to whoever is willing to help me.

[pbaldy]

Try

=IIf(Exam>=.7,"5% dicount of exam processing fee")

[AmandaMc]

Ok im going to try this.. thank you

[pbaldy]

No problem. With the quotes, you were comparing two literal strings, which would never have been equal.

[AmandaMc]

it still hasn't work , any more options?

[alcapps]

used this formula =IIf("Exam"=">=70%","5% dicount of exam processing fee") but nothing happened with the figures.

is Exam a numerical Field if it is try

=IIF([Exam]>=.85,[Fee]*.95,[Fee])

[pbaldy]

I guess I'll get out of the way.