update duplicates question

  • Thread starter Thread starter lez08
  • Start date Start date
L

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
 
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 :)
*
 
Hi Crystal,

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

Kindest regards
Les
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Access Passing the value to a table 1
Concatenating the same field from multiple records 16
removing duplicates using a criteria 3
combining queries into 1 8
3 queries into 1 8
Query returning duplicate/unexpected results 3
How do I update and delete at the same time 6
How to make a query records as criteria to the other query 1

Back
Top