Delete query - Access

[BLeonard]

Trying to build a delete query. Starting it out as a select to make sure its pulling the correct data. I know it should pull 1 row. Here is the SQL.

SELECT Site_Notes.Store_Nmbr, Site_Notes.Store_Note, Site_Notes.Store_Note_User, Site_Notes.Store_Note_Date
FROM Site_Notes
WHERE (((Site_Notes.Store_Nmbr) In (select site_tracking.store_nmbr from site_tracking where site_tracking.site_complete = yes)) AND ((Now()-[Site_Notes].[Store_Note_Date])>720));


When I remove the "where site_tracking.site_complete = yes" from the WHERE clause it works but I need that criteria. Ideas?