How can I have the query return a 0?

M

matjcb

Fist I would like to say thanks, this site is awesome.
I have a query looking at dates on a table, but if it doesn’t full within
the range given, it returns nothing. How can I have the query return a 0?
 
S

Stefan Hoffmann

hi,
Fist I would like to say thanks, this site is awesome.
Click to expand...
This is a newsgroup, not a web site...
I have a query looking at dates on a table, but if it doesn’t full within
the range given, it returns nothing. How can I have the query return a 0?
Click to expand...
Can you post your query SQL statement?

If you like a zero instead of NULL for a field, you may use the Nz()
function:

fieldNotNull: Nz([fieldName], 0)


mfG
--> stefan <--
 
Top