update duplicates question

[lez08]

I have an inventory table which has duplicate values and am looking for a
way to update the table so I can add the duplicate value and combine into
one record for each value

Let me explain, It is an inventory table I have a product, prodID 1049 qty =
5, within this table prodID 1049 appears again qty = 3

So what I want is a qbw method that will give me one entry for prodID 1049
qty = 8

Their are more than one duplicate product so need to search for all
duplicate prodID's and add all qty's

Many thanks

 

[strive4peace]

It would probably be easiest to write the data to a temporary table
using a query to total the quantity for a given productID, then delete
the data in the Inventory table, then append the records from the
temporary table back to the Inventory table.

What are the field names in the table?

.... but if this table shows transactions with a date, it may be best
just to add things up when you need them...

Warm Regards,
Crystal

remote programming and training

Access Basics
8-part free tutorial that covers essentials in Access
http://www.AccessMVP.com/strive4peace

*
have an awesome day
*

 

[lez08]

Hi Crystal,

Many thanks for the reply, thats exactly what I have done.

Kindest regards
Les

 

[strive4peace]

you're welcome, Les happy to help

Warm Regards,
Crystal

remote programming and training

Access Basics
8-part free tutorial that covers essentials in Access
http://www.AccessMVP.com/strive4peace

*
have an awesome day
*