How can I have the query return a 0?

  • Thread starter Thread starter matjcb
  • Start date Start date
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?
 
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 <--
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Query returning data for every day of a period. 1
linked tables query 9
Query Returning too many records 4
Query Search Criteria 2
Pulling data from date range query 2
How to structure a Table with many, many, many Fields? 16
Coding an External Query into a Query 2
Query Parameter using multiple options 0

Back
Top