I am not an expert but I am trying to develope an access program and have hit the following snag:
Using the queries in one of the fields there is an inserted amount say 3, now if that amount exceeds 3 I want to either * by a different number or add an additional amount. How do I do this and how is it written?
I have tried using the IIf and > but then I get stuck as there is no THEN or ELSE in the program.
Hope someone can help
Regards
John