chaverly
asked on
Use isnull in an Access 2007 query
I am trying to use isnull(Address2, '') and I'm getting an error. I don't know how to declare it in Access.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
IIF (ISNULL(Address2),'',Addre ss2);
IsNull(Address2) returns False if address2 exists, and True if it is not entered and the field was defined to accept (null).
chaverly,
I think IrogSinta's comment is like mine and was submitted some seconds before mine.
I think IrogSinta's comment is like mine and was submitted some seconds before mine.
Nz(Address2,"")