With the new era of mobile computing, smartphones and tablets, wireless communications and cloud services, the USDA sought to take advantage of a mobilized workforce and the blurring lines between personal and corporate computing resources.
'this works DELETE DISTINCTROW N.*, N.Imported FROM WorkTime_Actual_tbl AS N INNER JOIN WorkTime_StaffAndWorkDate_Uploaded_qry AS U ON (U.WorkDate = N.WorkDate) AND (N.Staff_tblPK = U.Staff_tblPK) WHERE (((N.Imported)=-1));
'this does not work 'error message --> could not delete from specififed tables DELETE N.*, N.Imported FROM WorkTime_Actual_tbl AS N INNER JOIN WorkTime_StaffAndWorkDate_Uploaded_qry AS U ON (N.Staff_tblPK = U.Staff_tblPK) AND (N.WorkDate = U.WorkDate) WHERE (((N.Imported)=-1));
|MS Access: How can you detect deletions after they are done, while NOT having Confirm Record Changes set||31||40|
|Link Excel Spreadsheet to Access, not using Transferspreadsheet||5||23|
|How to include a comma in a currency field within an expression in a query in Access 2010||3||27|
|Search Form not Querying||2||10|
Join the community of 500,000 technology professionals and ask your questions.
Connect with top rated Experts
23 Experts available now in Live!