"Null"

when a numerical query returns empty how do you make it show as 0?

You can use the Nz() function to replace a null to
whatever value you wish. The format is:

Nz(expression, value)

where expression could be a single field name or more
complex expression, and value can be numeric (such as 0
in your case), or a string enclosed in quotes.

HTH, Ted Allen
-----Original Message-----
when a numerical query returns empty how do you make it
show as 0?
.

By using the NZ function e.g.

SELECT Nz(numberColumn,0)
will return a 0 if the numbercolumn is blank.

Hope This Helps
Gerlad Stanley MCSD
-----Original Message-----
when a numerical query returns empty how do you make it
show as 0?
.

Have you tried the nz function (null to zero)? Just
replace the field that is returning nulls, e.g. "Cost" to
nz([Cost]).

-----Original Message-----
when a numerical query returns empty how do you make it
show as 0?
.
In the query design view, put this in the Field Row

Value:Nz([field],0)

Look up Nz in help (Null suppressed, first parameteris
inpt, second parameter is value if null)