Hello All!
I have a report that gives the total number of people registered for camp.
Each registrant has to have a "Type", a "Group", "Program Level", and a "Grade"
This is fine for the girls (it's a Girl Scout Camp) ... so a 3rd grade Brownie is a "G" (type = girl), a "Girl" (group), "BR", and "3"
While a 7th Grade Cadette is a "G", "Teen", "CD", "7"
We separate our middle school and up campers as "Teens".
However, an Adult is "A", "Adult", "Adult", "A".
Many reports order by grade or by group so Adults have to have a value in each field (actually, there are lookup tables, but once the query is run, the query pulls from those tables and populates).
For some things, I have to report total adults and total campers (Girls and Teens). Other reports require a count of each grade level or program level.
I have a report that sort of combines everything and there is some redundancy I'd like to get rid of, if possible.
First, it groups by Type, then by Group, then Program Level, then by Grade.
This is perfect for the campers:
G (All the campers)
Girls or Teens
Program Level
Grade
Each Grouping level has a total, I can look and see how many 5th graders we have or how many Teens or just how many campers.
But, for the Adults, it's very redundant.
A
Adults
Adult
A (grade and type are the same in this case)
And each Grouping has a total, so, right now its:
A 64
Adults 64
Adult 64
A 64
Is there any way to suppress the Group, Program Level, or Grade Headers if they are a certain value? (like if the Program Level is "Adults," don't show it, but if it's "Brownies" do show it)
Then I could have a report that has one line that totals the adults and then the campers are further grouped and subtotaled.
Thank you!
Susie
Kansas