I don't understand the first part of your problem but you can create a table
from your query.  You need to change your 'select query' to an 'append
query'.  When you click Run ! it will ask you if you want to append to an
existing table or a new one.  Let me know if you need more help with this.

Alison

From the error description it sounds like you might be linking to non-Access
data such as Excel or a text file, in which case you won't be able to delete
rows in the source from within Access.  One thing you could do is 'mark' the
records as deleted, but not actually delete them.  To do this create a local
table with a column or columns which match the primary key of the linked
table (or any column or combination of columns which identify a row
uniquely).  Make sure these  column or columns in the new table are defined
as its primary key.  Give this other table one more column of Boolean
(Yes/No) data type called something like Deleted.  Make its Display Control a
check box in its properties sheet in table design.

You can then join your query to this table in another query in which you
return all columns from the existing table and just the deleted column from
the new table.  You can then check those you want to mark as deleted.  When
you want to see the rows from the existing table without those marked for
deleted you just join the existing table to the new table in a query and set
the criterion for the Deleted column to False.

Ken Sheridan
Stafford, England