Report displaying Query.

[Tia]

I have a report called Service Reports. It consists of a main report and a
subreport. The main report has its information gathered from a query. It
displays the Customer Name, Address, and Manager's name and service tests
that need to be completed.

The Subreport is linked to the main report by the Customer ID and type of
system to be serviced. It lists all systems according to the type per
customer. Different systems are serviced on different weeks. For example:
0=every week, 1=first week of month, 2=second week, 3=third week, 4=fourth
week, 5=quarterly service, 6=bimonthly on even weeks, 7=bimonthly on odd
weeks. Service is, also, categorized as S=summer, A=Annual, W=Winter.

I have created queries that I can apply to the tables that sort the
information according to weeks that go together. For example, if I need all
service for the first week of the month, my query pulls all systems that have
a 0, 1, and 7. I use a form to open the report and apply the correct query
for the desired week. When the reports open, it divides the systems by
customer and system type, which is correct, but it then seperates them
according to whether it has a 0, 1, or 7....So instead of having one report
per customer per type of system with all systems listed in the query, I've
got multiple reports.

Basically, I want it to take the query and group according to the system and
display on the report accordingly so I only have one report per customer per
type of system. Is this possible????



I'm open for any suggestions or ideas because I'm at a loss.....Thanks for
any help that can be offered.