Novice
Windows 10 
Access 2016
Hello,
I have a cell that looks up a value from a query. When that lookup is null, I would like the cell to show a $0.00 value so that the calculated cell (Contract Value + Change Order Value) can perform its function.
Currently, the formula I am using is:
=DLookUp("[SumOfTOTAL]","SUM_ChangeOrders_Query","[Job Number] =" & [Forms]![MAIN_MENU]![txtJobN])
How would I write it to make it show a $0.00 for a null? Not sure how to use the NZ function in this format.
Thank you!
VIP
Windows 10 Access 2010 32bit
You can wrap the DLookup in the Nz() function ;
=Nz(DLookUp("[SumOfTOTAL]","SUM_ChangeOrders_Query","[Job Number] =" & [Forms]![MAIN_MENU]![txtJobN]),0.00)
Last edited by Minty; 02-20-2018 at 10:00 AM. Reason: Removed dufus paste = = = =
DLookup Syntax and others http://access.mvps.org/access/general/gen0018.htm
Please use the star below the post to say thanks if we have helped !
↓↓ It's down here ↓↓
Novice
Windows 10 Access 2016
Thank you!
Novice
Windows 10 Access 2016
It is saying that the formula has invalid syntax....thoughts?
Who is John Galt?
Windows XP Access 2007
Remove the = before DLookup.
VIP
Windows 10 Access 2010 32bit
Oops - cut and paste fail - sorry
DLookup Syntax and others http://access.mvps.org/access/general/gen0018.htm
Please use the star below the post to say thanks if we have helped !
↓↓ It's down here ↓↓
Who is John Galt?
Windows XP Access 2007
Shameful; I've never done that.Originally Posted by Minty
Oops - cut and paste fail - sorry
Dlookup problem - Invalid use of Null
Dlookup() for NULL
Posting Permissions
Reply With Quote