Report using multiple queries?

[Mike Sims]

I am in an odd predicament. I have a form that models our paper
purchase order for sending out a group of parts to a vendor for
treatment. In the form, I have two subforms. The first subform takes
in the list of parts to be serviced, and the second subform lists the
services which are to be performed on the sum of the parts. The form is
working correctly.

The problem comes in when I want to print out the PO using a report.
The services are line itemed in a table and are calculated based on the
sum of the parts. So if I am sending out 5 different part numbers, the
quantity of parts being sent is added up in the form and multiplied by
that vendors cost for each service to be performed. When I create a
query to pull all of the information I need for the report, each line
for each part number contains the cost of sending out all the parts. So
if I am sending out 5 different part numbers, the query returns 5 rows
for the first service being performed, and 5 rows for the second service
etc. The net result is that a running sum would be incorrect on the
report, and I am unable to just show the five part numbers on the
report. What I really need is a way to group the part numbers and the
services on the report separately as I have them in the form, and the
only way I can think of to accomplish this is to run two different
queries and populate a portion of the report with one query, then the
other portion with the other query, using the PO number as the key to
filtering out the information for each portion of the report. Access
cannot seem to do this. I know this is not a complicated thing I am
trying to do, but I think I may be going about it the wrong way.

Any ideas or suggestions would be very much appreciated.

Thank You,

Mike Sims

 

[Duane Hookom]

Use subreports on reports just like you use subforms on forms.

 

[Mike Sims]

Thanks Duane ... I didn't know one could do subreports at all.

You can see how often I use Access.

Thanks!