Home » Other » General » NVL Function in MS Access
NVL Function in MS Access [message #121201] Thu, 26 May 2005 16:43 Go to next message
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.

Re: NVL Function in MS Access [message #121260 is a reply to message #121201] Fri, 27 May 2005 04:12 Go to previous messageGo to next message
Frank Naude
Messages: 4579
Registered: April 1998
Senior Member
Try something like this:

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

Best regards.

Frank
Re: NVL Function in MS Access [message #121328 is a reply to message #121260] Fri, 27 May 2005 11:18 Go to previous messageGo to next message
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])
Re: NVL Function in MS Access [message #274701 is a reply to message #121201] Tue, 16 October 2007 21:08 Go to previous messageGo to next message
paithoonn
Messages: 1
Registered: October 2007
Junior Member
Your can use NZ function that is the same function like NVL on ORACLE.
Re: NVL Function in MS Access [message #274865 is a reply to message #274701] Wed, 17 October 2007 08:19 Go to previous message
joy_division
Messages: 4963
Registered: February 2005
Location: East Coast USA
Senior Member
Two year old topic has been resolved (hopefully).

closed.
Previous Topic: Oracle 10g on Windows vs Unix vs Linux
Next Topic: sample resumes for ab initio
Goto Forum:
  


Current Time: Thu Mar 28 08:03:20 CDT 2024