Deleting Duplicate records from a query result

[jdraw]

What is the common field in these tables? What field did you use for the Join?
Can you send new copy of the database?

 

[Desiderata]

In the attached pic, I want the query to remove the records in red and leave those highlighted in yellow. I can then run a count query to total the yellow records.

 

[jdraw]

There are no relationships in the attached file.

 

[Desiderata]

Here is a file with the relationships.

 

[jdraw]

I'm sorry - I have no idea what you are trying to do or what your relationships mean.