Counting records

[pirseinkim]

I have a report where I would like to count the records. I can do this in a typical way to count the records but I'm a little stuck on this scenerio.

In my report I pick a date range of 04/01/2013 to 04/30/2013 it displays all my records. I have 3 records for 04/01/2013 what I would like is for that to count 1, not 3. So on and so forth - so it will show me at the end of the report how many times a week they worked. Is there a way to do that?

Thank you in advance,
Kim P

 

[ted.martin]

You could create a new query that holds the records and then use the Query Totals functionality and Group on your Date and Count on another field e.g. the Primary Key

Then all you have to do is use this query as the data for little SubReport on your main report to give you the counts you require.