Grouping in Create Table Query

[Guest]

Hi,
I am combining several linked tables together in a create table query to
create a new table. I would like to group the new table by several different
fields .. first level would be job, second would be by the part field, and
the last would be by the stock no field. The summaries would be at the stock
no field level. How do I do this in the query so I only get one record per
Job, Part and Stock No?
Thanks!

 

[Doug Munich]

I don't know if there is a way to do the summary step in the create table
query, but it should be straightforward in a two-query way. Create your
table with the first query, then use that table as the source for the second
query, and using the sigma button group by Job, Part, and StockNo, and add
up whatever field you want.

Doug