Null result

  • Thread starter Thread starter David Tunstall
  • Start date Start date
D

David Tunstall

Please help.

I have a query that returns no results - it just shows
the headers. That is fine because there are no results to
show. But how can I show a zero instead of there being
nothing but the headers. I need this because I combine
three other queries in a report and obviously because
there is a null it screws up the totals.

Hope this makes sense
Many Thanks
David
 
David,

It seems to me that "showing a zero" in the empty query is not the
correct goal. If you need to include this query in another query, I
would imagine you need to use a Left Join within the second query, and
a Nz() function in the second query's outputs to cater to the
possibility of an empty data set. Please post back with more details
of the second query if you need more specific help with this.

- Steve Schapel, Microsoft Access MVP
 
obviously because
there is a null it screws up the totals.
Click to expand...

Can you use NZ() to convert a NULL to a zero, instead? A Query can't
really "return a zero" - a Query returns a Recordset, which might have
up to 255 fields and millions of records, rather than a scalar value.
 
Back
Top