Combining Information

[jzint]

I have a parts inventory table that contains a catergory, qty, part # ,
and a description field. It is updated by a form that either adds to
or subtracts from the inventory totals. What I am encountering is
duplicate entries with the same part number, but different quantities.
I would like to be able to combine these entries into one based on the
part number and add the quantities into one total. I am new to Access
and have very little VB knowledge.

[Allen Browne]

This is a big question, Joey, and there are *lots* of places where things
can go wrong.

For an introduction to the topic, see:
Inventory Control - Quantity On Hand
at:
http://allenbrowne.com/AppInventory.html

--
Allen Browne - Microsoft MVP. Perth, Western Australia
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

"jzint" <jo*******@irco.comwrote in message
news:11**********************@k70g2000cwa.googlegr oups.com...

>I have a parts inventory table that contains a catergory, qty, part # ,
and a description field. It is updated by a form that either adds to
or subtracts from the inventory totals. What I am encountering is
duplicate entries with the same part number, but different quantities.
I would like to be able to combine these entries into one based on the
part number and add the quantities into one total. I am new to Access
and have very little VB knowledge.