Microsoft Access 2010 Change this select query to a Delete Query

marlind

Registered User.
Local time
Today, 01:00
Joined
Oct 9, 2007
Messages
19
I need to delete the records that come from this query

SELECT qryforlastactivityyesterday.EmpName, qryforlastactivityyesterday.LastOfDateDBActivity
FROM qryforlastactivityyesterday INNER JOIN qryforyesterdaysreport ON (qryforlastactivityyesterday.EmpName = qryforyesterdaysreport.Employeeeod) AND (qryforlastactivityyesterday.Dateofentry = qryforyesterdaysreport.ReportDate)
WHERE (((qryforlastactivityyesterday.LastOfDateDBActivity)>[Appprovaldatetime]));
When I click on the delete icon I get the message specify the table containing the records you want to delete. I want to delete the records from qryforyesterdaysreport. Can someone help me on this. Thanks for any help.
 

Users who are viewing this thread

Back
Top Bottom