Delete Query Not Working

  • Thread starter Thread starter Allie
  • Start date Start date
A

Allie

I have a couple of queries set up to get a very select list of records. So
far, all of those are working properly. Now that I have what data I need, I
would like to write a query to Delete those results with matching IDs from
the original table.
Table "Records" - holds data regarding absences
Query "Sums" - calculates difference between dates, sums absences
Query "PrevAnn" - all records from "Sums" who's difference is greater than 1
year, except the most recent date.

Those are the records I would like to delete from table "records"

This is what I have for the "Delete" query:

DELETE Records.*
FROM Records INNER JOIN PrevAnn ON Records.ID=PrevAnn.ID

Am I on the right track here?
 
Annie,

Are you still trying to delete from the linked Excel spreadsheet, or did you
import into an Access table.

If you imported into an Access table, then you should be able to do:

DELETE Records.*
FROM Records
WHERE Records.ID IN (SELECT DISTINCT ID FROM PrevAnn)

--
HTH
Dale

Don''t forget to rate the post if it was helpful!

email address is invalid
Please reply to newsgroup only.
 
Back
Top