Simon, in your Total query, what is in the Total row under this number field
with the Is Null criteria?
If it says Group By, you are applying the criteria *after* grouping (i.e.
Access puts it in the HAVING clause.) If the total shows a number (even
zero), then the *total* is not Null.
To apply the criteria *before* gouping, drag the field into the design grid
a 2nd time, and use Where in the Total row. Move the criteria here instead
of under the instance of the field where you have Group By. Access puts the
criteria in the WHERE clause, and gives the behavior you expect.
--
Allen Browne - Microsoft MVP. Perth, Western Australia.
Tips for Access users -
http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.
"Simon" <S.******@HCCnet.nl> wrote in message
news:43***********************@dreader25.news.xs4a ll.nl...
I found out a strange behaviour in a query of the type Total (summation
query).
In case of a normal select query with a criteria setting Is Null for
field-A, four (4) records are found.
If I specify in a Total query for the same field Count where Is Null the
result is zero (0) records.
Is that because field-A is a numeric field?
How can I check in a Total (summation) query on fields without a value for
numeric fields?
