Re: query multiple records for a report

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

Pete P. wrote:

I am looking for assistance on running the "Purchase Orders" report in the MS
Access database template Inventory control. In this database each product has
a "Category" assignment. I need to have the categories for each of the items
on the P.O. show with a dollar total for each category. I have tried creating
a sub-report based on a category query. The appropriate information shows up
in the report previesw if only on item is shown. If multiple items are shown
in the "details" section of the report, the "category" sub-report (located in
the section below "details") registers only the last item from the details
section. Is there a way to get the sub-report to register data from each
record in the "details" section. Sorry for the length of this question. Any
help is appreciated. Pete P.


That's kind of vague so I'm not sure what you really need
here. However, there are several points that might be
relevant.

It sounds like you want the subreport to be in the detail
section. Be sure to set the subreport control's Link
Child/Master properties appropriately.

The group footer section is normally used to display totals
of the details in the group. This is easy to do with text
boxes that have expressions that use one or more aggregate
functions (Count, Sum, Avg, etc).

From what I can follow in your question, I don't see the
need for a subreport. Setting the report's record source to
a query that Joins the two table is both simpler and more
efficient.

--
Marsh
MVP [MS Access]
.