Grouping

T

Tia

I have a report and subreport that are not grouping the way that I like. The
report and subreport pull from the report queries. The queries display all
the correct records, however, when I move them to a report it seperates them
according to the service and the week. I think the problem is happening
because on the reports, I need all systems that are serviced marked A and W
need to print on the same report. However, they are getting seperated out.
Is there a way to right a code for the Service field on the report to group
all records of the same system that have an A or a W together on the same
report??? I will need to use a similar code in the Week field so that all
systems with either a 0 or the designated week # appear on the same
report.....

Any ideas on how to write this code, would be greatly appreciated...Thanks!
 
Top