Statistics query

[ScrmingWhisprs]

I am looking to come up with statistics for my volunteer tracker. I have a table of transactions that records who works each night we are building our haunted house. These transaction records record the Date, Worker and the Time In & Time Out. I would like (probably a cross tab query) that lists all the dates in the left hand column, and count the number of workers in another column, then the number of man-hours put in for that date. Kind of like this:

Date | Worker Count | Man-Hours
---------------------------------
7/30/2007 | 42 | 168
7/31/2007 | 31 | 124
8/2/2007 | 28 | 120
8/3/2007 | 17 | 68

Any help on this would be awesome. I have no experience with cross tab queries whatsoever.

SW

 

[Guus2005]

Use select query with group by, on the first(date) column, count on the second and sum on the third column.
For more info, post your table.
Enjoy!

 

[ScrmingWhisprs]

Thanks a lot!! It works great!

SW