Adding multiple entries

[ChrisGow]

This might be confusing so I will try to give as much detail as possible.

I have a table that has part numbers and the number of that part used that is based on a construction group lets call it.

I have another table that has all the different products that we sell, it also contains the "constuction groups" that are needed.

My append query looks to see which product is being ordered, gets the "construction groups" then looks at the other table and gets all the part numbers and quantity used in that group. It takes the part number,quantity used and appends them with an order number into another table. This works fine, however because some of the "construction groups" use the same part number I have multiple entries for some parts.

I want to be able to make it so that when there are multiple entries where the order number and part number are the same, it adds the 2 quantities and leaves only one record.

If someone out there even understands my problem could you help me. I have been trying to get this part of my db workign for a few weeks now.

 

[neileg]

If I understand your problem correctly, then your approach is wrong. You seem to want to be able to view your data in the table, as if it was a spreadsheet. Tables are for storing data, queries are for manipulating data, and you use a form or a report to view it.

You should create a totals query based on your table that adds up all the quantities where the order number and part number are the same. Then display this data in a form. Now it doesn't matter how many construction groups are involved.

 

[ChrisGow]

Thanks for the help i realized that i did not need that afterall but your suggestion would have worked