Line Item Summary Help

[Jeff Campos]

Let's assume an ordering database for t-shirts, sweatshirts and other "wearables." The "ordered items" table includes a Product_ID field, as well as fields for multiple garment sizes (small, medium, large, and so on).

For eample, let's assume there are three line items. The first shows an order for 20 small sizes of Product A. The second shows an order for 10 medium sizes of Product A. And the third shows an order for 10 medium sizes of Product B.

My need a summary layout showing the products and sizes. So in my example above, the summary would show:

Product A: 20 small, 10 medium

Product B: 10 medium

Thanks,

Jeff :(

[RalphL]

A report that gives your result in the form:

Product A

Small 20

Medium 10

Product B

Medium 20

Can be done with 2 sub-summaries.

If it has to be in the form you show, you could export the summary data to another table where it could be arranged the way you want it.