By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,647 Members | 1,124 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,647 IT Pros & Developers. It's quick & easy.

Combining Information

P: n/a
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.

Nov 16 '06 #1
Share this Question
Share on Google+
1 Reply


P: n/a
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.

Nov 16 '06 #2

This discussion thread is closed

Replies have been disabled for this discussion.