Sum Duplicates Query?

  • Thread starter Thread starter Ted Allen
  • Start date Start date
T

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
Click to expand...
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.
 
Hi Ted,
That did the trick! Thanks very much!

Ted Allen said:
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.
Click to expand...
 
Back
Top