I need to write a pretty long and extensive If statement in MS Access which looks at the values of other fields and determines a code to give the record. The if statement has a lot of arguments based on various value combinations in the record.
I'm ok with the syntax of If, Else statements, what I really want advice on is how to structure that statement in a module and call it from design view.
Tried various ways but having a lot of trouble.
Any help please would be appreciated.