How to force a zero into a blank field via a query in Access 2010

LillyC
LillyC used Ask the Experts™
on
Could anyone advice how I force a zero into a blank field in a query:

I have 2 cost columns and just want to deduct one from the other, so I need to force a zero into one of the columns where is doesn't return a value.
Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
NorieAnalyst Assistant

Commented:
You can use Nz for that.

Calc:Nz([Field2])-Nz([Field1])
Top Expert 2016

Commented:
try

expr: Nz([Field2],0)-Nz([Field1],0)
LillyCDatabase Developer

Author

Commented:
Great... thank you :)

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial