How do you to tell the query to delete rows from appropriate table?

[RHONDAK72]

I'm using Access 2003. I have a query that links 2 tables (Table A and Table B). The query identifies duplicate ids but only lists the inactive ids with a Where statement (Where Status <> "A"). I want to have these inactive rows deleted from Table B.

In Design View, I selected query type "Delete Query". When I tried to run the query, I received an error that said "Specify the table ontaining the records you want to delete." How do I do this? (Probably a simple answer but I'm not sure how to do it...)

The "Delete" row in Design View already specifies "Where" and it will not let me change it to "From" in order to specify the table from which to delete rows. Do I need to hard code something in SQL or is there a way to specify it in Deisgn View?

 

[jackd]

I'm using Access 2003. I have a query that links 2 tables (Table A and Table B). The query identifies duplicate ids but only lists the inactive ids with a Where statement (Where Status <> "A"). I want to have these inactive rows deleted from Table B.

In Design View, I selected query type "Delete Query". When I tried to run the query, I received an error that said "Specify the table ontaining the records you want to delete." How do I do this? (Probably a simple answer but I'm not sure how to do it...)

The "Delete" row in Design View already specifies "Where" and it will not let me change it to "From" in order to specify the table from which to delete rows. Do I need to hard code something in SQL or is there a way to specify it in Deisgn View?

Here's a link to a sample.
http://www.databasedev.co.uk/delete_query.html

Be careful. A delete query will remove data from your table. You may want to make a copy of the table first....just in case!!!!