To whom it may concern,
I need to say the following in MS Access, but I think that I am missing smth in my SQL code. Could someone tell me how to make the following work?
Expression1 is the field in my design view and the rest is the values that I want my field to assume.
Expression1: If ((var1>0 and var2=#12/31/9999#), min(var3,var1),var4)