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

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!

Thanks a lot!! It works great!

SW