Grouping

[Gary Nelson]

In Access2000, I have a query that is showing orders received on a given
day. I have the query is linked to a report.

The purpose of this report is to show our production department orders
received today. The report will give them the information they need in
order to produce our product. There are several instances when the same
item is ordered, and shows up on the report as a seperate entry, but has the
same part number, but different quantity.

I would like to group the orders that have the same part number, so that
only one order for the part number will appear on the report, but also sum
the quantity.

For example:

Part Number: Quantity:

123456 2
123456 1
123456 2

I would like it to appear as follows:

123456 5

Can you please offer some assitance as to how my query or report should be
adjusted?

Thanks,
Gary

 

[Duane Hookom]

It looks like you could use a totals query that groups by Part Number and
sums the quantity.