Queries to return 0 ????

[paulmcdonnell]

Hi guys, this should be a quite straight forward one....

I have a set of 6 count queries which count different conditions in different tables.

hence some will return 2,1,20, etc as resultant counts

another summary query uses the count of each orginal query so that it provides the base information for a report that summarieses total counts for different areas.

The summary query works fine when there is a produced resultant by all the other count queries
If one of the original counting queries returns 'nothing' then the summary query result is 'nothing' also, whether other queries have resultants or not.

If a count query returns no records how can I get it to reutn the Value 0

Cheers
Hope you can help!!!!!!!!
Paul

 

[Adrianna]

Just a shot in the dark, but if you're running all of these queies through code...isn't there a way to check if
IsNull([Queries]![NameQuery]![countfield]) Then

and either have the query bypass that table


OR set the default of the fields in the FINAL COUNT query report to zero