Query does not count all records

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I know I am new at this but seriously, I have a table that has 105,592
records in it. I build a query that works fine until I add the total row in.
Once the total is added and right now I just have it at Group then I end up
missing 1500 records or so from the main data.
Is this because of the Null value?

Thanks,
 
Chris,

Most likely. If you are doing a count to get the number of records,
recommend you do COUNT(*) rather than Count([FieldName]). If you use a field
name, it will not count the NULL values.
 
Chris said:
I know I am new at this but seriously, I have a table that has 105,592
records in it. I build a query that works fine until I add the total row in.
Once the total is added and right now I just have it at Group then I end up
missing 1500 records or so from the main data.
Is this because of the Null value?
Click to expand...


Most likely that because a Totals query with nothing but
Group By in the totals row doesn't so anything except
suppress duplicate records in the result dataset. If you
change a the entry to Count in a field that is supposed to
be unique and add a criteria of >1 for that field, you
should see just the records where that field is not unique.
 
Thanks, I will give that a try...

Marshall Barton said:
Most likely that because a Totals query with nothing but
Group By in the totals row doesn't so anything except
suppress duplicate records in the result dataset. If you
change a the entry to Count in a field that is supposed to
be unique and add a criteria of >1 for that field, you
should see just the records where that field is not unique.
Click to expand...
 
Back
Top