Counting in reports

Hi Gary

Thanks for your question

I think a Grouped summation query will solve your first problem

Create a query with the staff field in twice. (They should be the only two fields in the query)

Then click the sigma button to add the grouping options. In the "group by" column in the second staff field change the setting to count, and run the query.

As to your second problem, I'm not sure that this can easily be achieved in an Access query. I suggest exporting the ungrouped query into excel and building a pivot table. I will however explore things further and if I find a soloution I will repost here

Reagrds

Stephen