Need help with a query (1 Viewer)

[Richard M]

I have a query to count the number of rows in a field that contains number data. The problem is when there is no data at all, I can not get a count of 0. This gives me problems with other queries that uses this data.

I am using Totals in the query with the field count to count the records. Works great when there is some data in the field.


Field test: MyFild
Table MyTable
Tables count

Any help to what I am doing work will be appreciated.

Richard

 

[Richard M]

Solved the problem by changing the Total in one field from group to where. Now I get a count of zero when there is no data to be counted and when there is data, it is counted.

Richard