How do I sum entry types in a report?

[avarusbrightfyre]

I have a database that tracks events my organization attends and the type of event it was. It also records the date of the event.

I need to generate a report that will count the number of each TYPE of event and display one entry for each TYPE and the TOTAL NUMBER of events that appear on the table between two specified dates.

I have a report based on a query that pulls the FROM DATE and TO DATE from two text boxes on a separate form. This should filter out the dates I want, but I still need to have something that looks like this:

Event Type 1: 25
Event Type 2: 50
Event Type 3: 15
Etc.......

What would be the best way to simply count the number of times a specific entry type appears between two specified dates? I would prefer to not have to add 15 or 20 different queries if there is a simpler way.

[NoellaG]

HI,

you can wite a totals query, grouped by event type and a count function, or you can even do the grouping on the report itself, just look at the grouping and sorting possibilities there.

grNG