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: 4502
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: 4644
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: Sat Dec 10 14:37:33 CST 2016

Total time taken to generate the page: 0.11041 seconds