Slimfit
asked on
How to use DLookup with IsNull Function
Can somebody help me out. I am trying to use DLookup to return null value or semi-column if it is not null. Then I Code this way:
If IsNull(DLookup("FieldName" , "tblName"), " " , ";" )
And it does not work. I will appreciate it, if somebody can tell me what I am doing wrong.
Thanks,
Slimfit
If IsNull(DLookup("FieldName"
And it does not work. I will appreciate it, if somebody can tell me what I am doing wrong.
Thanks,
Slimfit
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Maybe you mean this ...
Nz(DLookup("FieldName", "tblName"), " ") , ";" )
Nz(DLookup("FieldName", "tblName"), " ") , ";" )
ASKER
It solved the problem. Thanks a lot. I really appreciated it.
Slimfit
Slimfit
DLookup already returns a Null if the criteria is not met or no such value exists.
I really don't understand your question.
Also, DLookup() only has 3 arguments ... you have 4 ...