Merging duplicate records

D

DaveNicol31

I'm importing a csv file into Access from a handheld scanner that is used to
count inventory. There are muliple records with the same product number in
the file. Is there an easy way to summarize all records with the same product
number. The scanner record layout is Product Number, Quantity, Date, Time.
For example, if there are 2 records with product number 1234 and one has a
quantity of 4 and the other a quantity of 5, I would like to end up with one
record in Access with a quantity of 9.
 
T

ti976

Yes, if you just want product number & quatity.
use the group function button (sigma symbol) select product number &
quantity.
for quantity, change the 'group by' criteria to 'sum'
 
Top