Looping a query and keeping values for calculation.

Looping a query?

I have a query that runs through my main table selecting dates with a count and group by, so It shows how many seperate days there are in the query. Thing is each day could have 3-4 jobs allocated to it each with different staff..

So I need the query to run through but with a where statement, the where statement will be the staff names. The staff are kept in a seperate table so I need the loop to go through the 'staff' table and run the query for each member of staff and keep the end value so I can use all the values in another calculation..

Can I use OpenRecordset ???

Im getting the impression from reading around that I can use a Count() and group by in a query to get how many days are in the main query... then some another query that uses that result and this openrecordset??

Im just not sure about this openrecordset at all.