Access Delete Query Specify The Table Containing The Records. Optionally you can enter criteria for one or more fields in the Criteria row of the designer and then clear the Show check box for each criteria field. Its a very powerful feature and a fundamental part of relational databases since you can remove multiple records at one time and can specify which records to delete by linking to data in another table.
Start date Aug 19 2009. This works perfectly line spaces added for clarity. When I try to build the Delete Query either with the query used to identify the records to delete or with another query using that query I get the message Specify the table containing the records you want to delete Here is the SQL from the query used to find the records to delete.
This works perfectly line spaces added for clarity.
When I link now this 2 tables then run the query it prompts me. I want to delete records from a table. Create and run a delete query - Access Creates a delete query that removes records from one or more of the you use DELETE only the data is deleted. My recommendation would be.
