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.