Delete Query

  • Thread starter Thread starter Steve
  • Start date Start date
S

Steve

I have a table with names (tblQualifications) of
people/qualifications that belong to a department/shift.
I also have a query (qryExceptions) that shows which of
those people are on vacation or otherwise not available
(this query does not use tblQualifications). I want the
resulting names of qryExceptions deleted from
tblQualifications. Racking my small brain. Any help
will be greatly appreciated.
Thanks
 
I have a table with names (tblQualifications) of
people/qualifications that belong to a department/shift.
I also have a query (qryExceptions) that shows which of
those people are on vacation or otherwise not available
(this query does not use tblQualifications). I want the
resulting names of qryExceptions deleted from
tblQualifications. Racking my small brain. Any help
will be greatly appreciated.
Thanks
Click to expand...

Do you want to permanently and irrevokably delete these people from
tblQualifications? Is it ok that they must be reentered into the table
when they come back from vacation?

If so the syntax would be

DELETE * FROM tblQualifications
WHERE PersonID IN (SELECT PersonID FROM qryExceptions);

Somehow I don't think you really want this though!
 
-----Original Message-----


Do you want to permanently and irrevokably delete these people from
tblQualifications? Is it ok that they must be reentered into the table
when they come back from vacation?

If so the syntax would be

DELETE * FROM tblQualifications
WHERE PersonID IN (SELECT PersonID FROM qryExceptions);

Somehow I don't think you really want this though!


.
Thank you John. Yes I do want to permanently delete
Click to expand...
since it is a temporary table.
 
Back
Top