Writing Query Results to New Table

[quigongrim]

I've run a query to find all records that aren't selling in my database. I now need to write these results (just their Item Numbers - primary key) to a new table that has new fields that the original query doesn't.



Does any know how and if I can do this?

[weekend00]

Do you mean you can save the reult of the query, but the query doesn't include the field "ItemNumber"? Why don't just add this field to you query?

[quigongrim]

Do you mean you can save the reult of the query, but the query doesn't include the field "ItemNumber"? Why don't just add this field to you query?

It's just the Item Number I need to carry across, the other fields in the new table I need to populate myself. Basically, I'm using Access to create a list of item numbers, which I can search through and then tick an completed box and type in some relevant notes as well as a due date.