monthly table with serveral dates count

[daasha]

I need to be able to count how many fields per date. I've tried several ways to add this to my query, but nothing seems to combine the dates, it just gives me nothing or 1 as the count for every line even when it is the same date......

[JoeM]

It sounds like you may want an Aggregate (Totals) Query, but it would probably be best if you can show a sample of your data and expected result, so we know for certain exactly what it is you are trying to do.

[daasha]

It sounds like you may want an Aggregate (Totals) Query, but it would probably be best if you can show a sample of your data and expected result, so we know for certain exactly what it is you are trying to do.

Here is the table I am working from.


the query.

the query results
Instead of all one's, the lines should be combining the dates since I have more than one line with the same date, so I should have more than a count of 1.

[JoeM]

That's because you have different values in all your Time fields.

Trying doing an Aggregate Query where only add the following fields:
- Clerk
- Date
- Date (add it a second time).

Then, make it an aggregate where you group on the first two fields and count the third, i.e.
- Clerk (Group By)
- Date (Group By)
- Date (Count)

I think this will give you what you are looking for.