Deleting a record from a Query

C

Christine

Hi
I'm very new to Access and I was wondering how do you delete a record from a
query result? Every time I try to do so it gives me the following error
"Deleting data in a linked table is not supported by this ISAM" . I've run a
Query to get all records that contain a segment of text, but now I need to
further "prune" the records. I can't do another filter or query as there are
no particular words that I want to keep or get rid of. I need to evaluate
each record one by one. I know I can save a query, but can I save the query
results as a table and then further manipulate them?
Thank-you very much in advance for your help
 
A

AlienzDDS

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
 
K

Ken Sheridan

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
 
Top