OraFAQ Forum: General » NVL Function in MS Access

Home » Other » General » NVL Function in MS Access

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

NVL Function in MS Access [message #121201]

Thu, 26 May 2005 16:43

mikeylbc
Messages: 2
Registered: May 2005

Junior Member

Does anyone know if there is an equivalent NVL Function in MS Access?

I used a switch function to correct the issue, but I was curious if there was a cleaner way of doing it.

Report message to a moderator

Re: NVL Function in MS Access [message #121260 is a reply to message #121201]

Fri, 27 May 2005 04:12

Frank Naude
Messages: 4575
Registered: April 1998

Senior Member

Try something like this:

=IIf(IsNull([Region]),"Region field is NULL")

Best regards.

Frank

Report message to a moderator

Re: NVL Function in MS Access [message #121328 is a reply to message #121260]

Fri, 27 May 2005 11:18

mikeylbc
Messages: 2
Registered: May 2005

Junior Member

That's much cleaner Razz

Thanks

Mine looked something like this, but was very unclean due to the else statement becoming very large if I had multiple criteria.

Switch([Region] Is Null,18,[Region] Is Not Null,[Region])

Report message to a moderator