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.
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.