Replies

No. That’s the problem. My query is based on the Status. If there is a record for status=Mandated for all 8 people, then all the names will show up. I guess I can have a query update the main table to put one record for each person with a status. The reason for these three embedded is that owner of the report wants the totals to stretch across the page. I may just have to offer him a totals report that is vertical like in the attached:

Here is my goal
A B C D
NAme01 ———————– 0——-4——-5———6
NAme02 ———————– 0——-3——-7———3
NAme03 ———————– 0——-6——-8———0

Instead here is what I get:

A B C D
NAme01 ———————– 0——-4——-5———6
4——-5———6
8———0

Where: Because there is only one record for status A, the name for that person is showing. For Status B, there are only 2 records. etc.

If this is too confusing, open up the first Attachment above. then open up this attachment and compare.