Count Query

[Guest]

I need to get a count of how many calls a person logged by month. My field
names are Staff and Call_Date. I know how to get a count of how many each
person did all together using a date range but I dont' know how to do it by
month in one query. My date field is in mm/dd/yyyy format. I wrote a query
that uses Group By and Count on the Staff field to get my counts for a date
range - I just wondered if there was an easier way than running the query 3
times with a different date range for each month in a quarter.

Thanks!

 

[Tom Ellison]

Dear Lori:

To escape confusion now and in the future, the "format" of your date field
has no effect on what is stored, or how you would filter using it.

Next, I don't know what you want in the 3 month wide query. Surely you
could filter BETWEEN 1/1/2006 AND 3/31/2006 to see 3 months worth. Do you
want to filter by this and still see to which month each row belongs? Add a
column with Month(Call_Date) to see the month number, or Format() it to show
the month name.

Remember that, if you have a column that says Jan, Feb, Mar, etc. it will
not sort chronologically!

Tom Ellison