How to turn a Null Value in a Query to Zero

  • Thread starter Thread starter Barry
  • Start date Start date
B

Barry

I have been strugling to get a column in a query which has
a combinations of cells with numbers and others which do
not have numbers and are there fore NULL.I want Access to
put zeros in the NULL cells so that when I do a grand
total of two columns, the Grand total will show a value
for those rows which have Null values.
 
Dear Barry:

You can use:

Nz([Your Column Name Goes Here], 0)

For more details, see online help.

I have been strugling to get a column in a query which has
a combinations of cells with numbers and others which do
not have numbers and are there fore NULL.I want Access to
put zeros in the NULL cells so that when I do a grand
total of two columns, the Grand total will show a value
for those rows which have Null values.
Click to expand...

Tom Ellison
Ellison Enterprises - Your One Stop IT Experts
 
Back
Top