Missing Records

L

lovens

If I run a Simple Query, and then delete a couple of records in that query,
it also deletes the info in the primary table.

How do I prevent this?

Thanks for your input.

lml
 
O

Ofer

Does the query based on this primary table?
The query output the records that in the table, so deleting any records from
the query it just as deleting records from the table.
The query is the table itself, it just allow you to display the records in
the table/s in different way, but it still the table
 
L

lovens

Yes, the query is based on the primary table. Isn't there a way to prevent
ANY records being deleted from the primary table from corresponding queries?
I ran a query and it gave me a couple of records I didn't need, so I would
like the option to remove them from the query output without deleting them in
the primary table. Would changing relationship criteria work? I didn't set
up the database, and since I'm fairly new to Access, I don't want to do
something until I know what options I have. I work for the State in which I
live, and it is critical that we get this issue resolved.

Thanks again for any assistance.
lml
 
K

Klatuu

The only thing you can do to avoid getting the records you don't want is to
refine your query parameters to include only the records you want.
 
G

George Nicholson

Change your query to a MakeTable query and then work with the new table. You
can safely delete records from the new table (which contains only what the
query did) without changing the original data.

HTH,
 
Top