Sum Duplicates Query?

[Ted Allen]

Hi Mike,

Just create a query in design view, add your table, add
both of the fields to the design grid, then right click
on the design grid and choose Sum Totals. Under the
barcode field, choose "Group By" (this will probably be
the default), and under the quantity field choose "Sum".
When you view the query it should group by the barcode
values and sum all corresponding numbers in the quantity
field.

If you want to create a table from this query, just
change the query type to "Make Table" and specify the new
table name.

Hope that helps.

-Ted Allen

-----Original Message-----
I am very new to Access. What I need to do is probably

very simple, but I still need some guidance. I have a
table with two fields. One field contains barcodes that
represent products and the other field contains
quantiyies of the barcodes. The data source is a
handheld data collector. The duplicates come from the
fact that we have merchandise in more than one location.
I want to sum the quantities of the duplicate barcodes
and eliminate the duplicates being left with one version
of each barcode that has the quantities of all barcode
duplication. Any and all help will be appreciated.
Maybe a website or another newsgroup or a manual,
whatever you got.

 

[Mike Burnett]

Hi Ted,
That did the trick! Thanks very much!

Hi Mike,

Just create a query in design view, add your table, add
both of the fields to the design grid, then right click
on the design grid and choose Sum Totals. Under the
barcode field, choose "Group By" (this will probably be
the default), and under the quantity field choose "Sum".
When you view the query it should group by the barcode
values and sum all corresponding numbers in the quantity
field.

If you want to create a table from this query, just
change the query type to "Make Table" and specify the new
table name.

Hope that helps.

-Ted Allen
very simple, but I still need some guidance. I have a
table with two fields. One field contains barcodes that
represent products and the other field contains
quantiyies of the barcodes. The data source is a
handheld data collector. The duplicates come from the
fact that we have merchandise in more than one location.
I want to sum the quantities of the duplicate barcodes
and eliminate the duplicates being left with one version
of each barcode that has the quantities of all barcode
duplication. Any and all help will be appreciated.
Maybe a website or another newsgroup or a manual,
whatever you got.