Multiple Sub-Totals in a Report

[lexiwynona via AccessMonster.com]

Thanks John for helping me with my "<> and <>" QUERY question from last week.
It worked like a charm.

Now I need to count different fields in a report. Currently I have CR
(Condition Reports) which are totaled by the staff member working the
individual CR. I have "=Count([full name])" which works great for the TOTAL
CRs for "full name" sub-totals.

However, now I need to also count by Level of CRs (A,B,C or D) by Full Name.
For example:

CR100 Level B Smith
CR104 Level C Smith
CR105 Level C Smith

Total CRs for Smith = 2 Total Level B = 1 Total Level C = 2

CR101 Level A Jones
CR105 Level A Jones

Total CRs for Jones = 2 Total Level A = 2

Can I perform this in within the report or do I have to write separate
queries?

Thanks in advance,
Lexi

 

[Duane Hookom]

I would probably use a multiple column subreport in the staff member footer.
Base the subreport on a totals query that counts and groups by staff and
Level of CR.

If your levels of CR will absolutely never change, you could use simple text
boxes in the staff member footer with control sources like:
=Sum(Abs([CR]="LevelB"))