OK I am very pretty new at Access as I have mostly always used Excel for most things. However, I am kind of stuck here. I need to write an expression /w multiple If conditions. Basically I have a dlookup field as so:

Ent Due Date: DLookUp("[Due Date]","tblTrainingDates","[Course ID] = '" & [Item Id] & "'")

Now I need to create another field based off of that.... if I was doing this in Excel it would be: =IF(AND(C2<>"",C2>B2),"Y","N") if C2 = [Ent Due Date] and B2 = [Completion Date].

Basic idea is I want a field saying "Y" IF [Completion Date] > [Ent Due Date] AND [Ent Due Date] Not Null.

I hope that makes sense....

See the IIF() (Immediate If) function in the Help file for details.

Sam

Well now I feel stupid lol... in hindsight that was kind of obvious.

Thanks for the help.

You're very welcome.

Welcome to Access!

Sam