Count the Number of staff who are in the month

[57oln]

Hi again,

I need some help to count the number of people who worked in a month.

I have a table similar to the below. note date format is dd/mm/yyyy

Date	Who	Task 1	Task 2	Task 3
01/01/2012	Tim	50	10	2
01/01/2012	Jane	10	20	50
02/01/2012	Tim	90	0	0
02/02/2012	Tim	50	8	22

<tbody>
</tbody>

I want my query to show

# of Staff in Month
January 2
February 1

Where January equals Tim and Jane (2) and February equals Tim (1) so on and so forth.

The names pull from a "Staff" Table I have to populate a combo box on an entry form.

Thanks again for the help in advance.

Jay

 

[SydneyGeek]

Create a query that groups on Date (by month), the Who (Staff) field.
Then base a second query on that; group by Date again, and Count the staff. Note: Don't use Date, Month, Year, Day as field names. They are reserved names / function names in Access, and will cause you problems. Do a search on Reserved Words, and avoid them. WorkDate is a good field name, as well as being more descriptive.

Denis

 

[57oln]

Create a query that groups on Date (by month), the Who (Staff) field.
Then base a second query on that; group by Date again, and Count the staff. Note: Don't use Date, Month, Year, Day as field names. They are reserved names / function names in Access, and will cause you problems. Do a search on Reserved Words, and avoid them. WorkDate is a good field name, as well as being more descriptive.

Denis

Thanks a stack SydneyGeek, I used your post and brought the document processing through the queries as well to give me a total report I needed.

I only used Date in this example my table is called something different.

Cheers and thanks again!!!

 

[SydneyGeek]

You're welcome

Denis