D
Dianne Groom
I have an Access database with two tables, a Client Details table with
Client ID as the key field, and a Client Visits table with Record ID, Client
ID and Visit Date fields.
I have created a Most Recent Visit Date query, with fields Client ID (Group
by) and Visit Date (Max).
I have tried to create a Delete query to delete all records for clients in a
specified date range.
I used * (all fields) from the Client Details table as the "From" field and
MaxOfVisit Date from the Most Recent Visit Date query as the "Where" field ,
specifying a date range as the criterion.
When I run the delete query the following message is displayed "Could not
delete from specified tables".
Your help would be appreciated.
Client ID as the key field, and a Client Visits table with Record ID, Client
ID and Visit Date fields.
I have created a Most Recent Visit Date query, with fields Client ID (Group
by) and Visit Date (Max).
I have tried to create a Delete query to delete all records for clients in a
specified date range.
I used * (all fields) from the Client Details table as the "From" field and
MaxOfVisit Date from the Most Recent Visit Date query as the "Where" field ,
specifying a date range as the criterion.
When I run the delete query the following message is displayed "Could not
delete from specified tables".
Your help would be appreciated.