Searching for some duplicates and some not duplicates

[whiteeagle]

I have several inspectors who inspect residential septic systems three times a year.  I need to find the property ids for the inspections where the property id is the same, the date is greater than 9/30/12, but the inspector is different in the two inspections that will show up for each property id.  I can import, export, add fields or whatever I need to do.  I am the administrator of the database so anything goes.

 

Thanks!

[mr_vodka]

If you create another table occurrence of the inspection table keyed on

 

Inspect::property_id = Inspect 2::property_id

Inspect::date_inspect <= Inspect 2::date_inspect

 

 

You can then find records > 9/12/2012 in your Inspect::date_inspect field.

 

Then you should be able to run a quick script that loops through your records and checks if there are more than 1 different inspector on the property_id.