I have 3 tables that I am working with table:
1. Patients includes: FacilityID, PatientID, PatientName, PatientSSN, NewPatient
2. Revenue includes: FacilityID, RevenueID, DateOfService
3. Revenue(MedB): MedBID, PatientID, RevenueID
I am not allowed to change the structure of these tables so I have to work with what I have. These table have no relationships.
Problem: I need to delete all the Patients from the Patients table where DateOfService is older than 2 month of January example prior 11/1/2007. This needs to be ran once a year so in January 2009 I need to be able to delete prior 11/1/2008...ect. Also the only records I need deleted are from Patients table only. The DateOfService from the Revenue table has to stay. This could be done in VBA or in Query. I'm trying query right now but seem to be stuck. Any Hints?