Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations bkrike on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

NVL in Access

Status
Not open for further replies.
rhino747a

rhino747a

MIS
Apr 25, 2005
7
ZA
Hi Guys,

Do any of you know if there is an equiverlent to Oracle's NVL function in access that can be used within the standard SQL select statement.

Regards

Dave
 
Sort by date Sort by votes
Take a look at the Nz function.

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ222-2244
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

Xavierparkash
  • Locked
  • Question
MS Access Slow Search in Linked Database
Replies
0
Views
419
Xavierparkash
Xavierparkash
Kennelbloke
  • Locked
  • Solved
Subform not updating in parent form
Replies
10
Views
959
Kennelbloke
Kennelbloke
PrimoSteve
  • Locked
  • Question
Fill in 2nd Textbox2 from Textbox1
Replies
3
Views
669
PrimoSteve
PrimoSteve
JanaLNelson
  • Locked
  • Question
Filter as you type combo box in Access 2
2 3
Replies
54
Views
3K
JanaLNelson
JanaLNelson
caykamanj1966
  • Locked
  • Question
Duplicate Records in DataSheet View
Replies
5
Views
714
Andrzejek
Andrzejek

Part and Inventory Search

Sponsor

Back
Top