I have an access db I am working with that has a lot of records. The form that originally generated the data had a drop down that had the following choices: N/A, Fair, Good and Excellent. There are 2 sets of records in 2 tables in the same db. My task is to match those records and display the results. My problem is that it's not a straight match. For example I need to match a record in table1 that has say "Good" in that field with any records in table2 that have Good or Excellent. I haven't the foggiest clue how to start writing that statement and changing the db and the form is not an option. Anyone vere run accross this type of situation? Help would be appreciated.