Append to table with Sum field

[fenhow]

Hi, I have a query that groups and sums. I need to do this to get the source data where I need it for ongoing processes.
Once I run the query the results work perfectly. I now want to take the results and append them to a new table. The problem is all fields will come in execpt the SUM field? I am stumped as to why? Any suggestions?
Fen

 

[Guus2005]

You stumbled on the hidden de-normalization protection shield which prevents you from doing this.

Oke, this is not true. That feature is disabled in your version

You should not store sum values.

But having said that it is a remarkable fact that it does what it does and without having seen your insert query or your table design it is difficult to say what is keeping your query from doing that or not doing that i mean.

 

[fenhow]

Thanks, so here is the scenairo.
I have a Bill of Materials that has several hundred parts on it.
In many cases there are duplicate parts in different places as the BOM is built from the CAD drawings. We want to consolidate the parts so if I need to order say 10 items of one thing but they are in the original BOM in 5 different places it is all summed up with on listed item versus the 5. My thougts were to take the original BOM run a group/sum query take the results and create a new table with that data moving forward. This is because once I consolidate the list we will be using this list to send out for bids and also tracking the items when they come back in.
Thanks.
Fen

 

[Guus2005]

So you have a BOM derived from CAD drawings and an original BOM.
This information is all in your database? If so, you should use a single query to produce the end result.
Again, i can't give you a detailed solution if i don't know what your tables look like.

HTH