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

Need to overwrite existing data

P: 58
I am using an update query which updates data in one table taken from a new weekly table. The only problem that I am having is they are not overwriting each other. it is making duplicate records.

example:

QTY:
12 - HOLSTEN
14 - HOLSTEN
15 - HOLSTEN
16 - HOLSTEN

I want the above to just have one QTYof 69:

69 - HOLSTEN
Jun 14 '07 #1
Share this Question
Share on Google+
1 Reply


puppydogbuddy
Expert 100+
P: 1,923
I am using an update query which updates data in one table taken from a new weekly table. The only problem that I am having is they are not overwriting each other. it is making duplicate records.

example:

QTY:
12 - HOLSTEN
14 - HOLSTEN
15 - HOLSTEN
16 - HOLSTEN

I want the above to just have one QTYof 69:

69 - HOLSTEN

Your update query is updating at the detail level. You need to do a summation query (click the Greek letter Sigma on your toolbar). Group by product ID or Name and Sum the quantity. I am assuming that you created and saved your query as a select query first, then converted it to an Access update query by clicking the query type on the toolbar and converting it to an update query which enabled you to enter the update specs.
Jun 15 '07 #2

Post your reply

Sign in to post your reply or Sign up for a free account.