DLookup

[Alex Motilal]

Hello. I am returning to the Forum after a long gap.

I want to set Yes/No field and Is Not Null field as criteria in DLookup Function. This I want both to set up in a Query and a Function in a Module. Please help me.



Regards,
Alex

[amrut]

Post you code/expression for specific help. the general syntax for Dlookup is
DLookup("FieldName","TableName","[SomeField]=True AND [SomeField2] Is Not Null")

[Alex Motilal]

Thank u amrut, your solution worked fine. Thanks again.