Jonathan has attended:
Access Intermediate course
If, function
How do I use the If function in Access?
RE: If, function
The IF function in access works the same as in Excel, however the name of the function is IIF. Also, instead of evaluating a cell, you would be evaluating a field name.
Look in the help section for IIF FUNCTION for all the fine details.