Hello. The Dlookup below works but does not seem to distinguish between the (1,4,5) [tblSubject_SubjectCode] criteria. Do I have the syntax right for this?
I am looking for any of the three - it could be literally a 1 or 4 or 5 in that field.
Any help with this would be appreciated ...