Grouping Number of Records by Month

[Guest]

The user of the database I created would like to know the number of Billers
(which is indicated by a checkbox when the record is entered into the
form)for each month. I can create a simple query that counts the number of
billers with the user entering a number of the month in the Open date field.
What is the best way to create a report based on month that is the date
field. I would like to group all the records entered in December and sum the
total.

Thanks,
Maria

 

[Rick B]

in the grouping and sorting just enter something like...


= Month([SomeDateField])


Rick B