Link to home
Start Free TrialLog in
Avatar of Slimfit
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
ASKER CERTIFIED SOLUTION
Avatar of chaau
chaau
Flag of Australia image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
semi-column ??
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 ...
Maybe you mean this ...
Nz(DLookup("FieldName", "tblName"), " ") , ";" )
Avatar of Slimfit
Slimfit

ASKER

It solved the problem. Thanks  a lot. I really appreciated it.

Slimfit