I am trying to make a report, but it is not behaving (notice how I blame the
software, never myself...). In a simple seminar database, I have fields to
track which of six cities patrons sign up for, and whether they sign up for
Day One, Day Two, or Both Days. Simple fields called SITE and DAYS.

I want the report to show how many have signed up in each city, and below
each city provide a breakdown for how many have signed up for Day One, Two,
or Both. I want this:

Chicago 35
Day One 7
Day Two 10
Both Days 18

Dallas 45
Day One 15
Day Two 12
Both Days 8

In trying to create the sub-summary, I am not getting totals for DAYS;
instead, I am getting a listing of each patron:

Dallas 45
Day One 1
Day One 1
Day One 1
Day One 1 etc.
Day Two 1
Day Two 1
Day Two 1
Day Two 1 etc.


That ain't right! What am I doing wrong and how can I fix it? Thanks...




Rick A.
Pleasanton