I know it sounds odd as a query is always about getting the results you want - the preferred results.
In this case i have a table with duplicate records for each job, species of plants and animals. Each species has its own unique number. The table contains species that were recorded by my company and species that were recorded by other people/companies, so that i can summarise and compare what we recorded versus what other people in the area recorded.
I need a unique or distinct query that will return only a subset of those species (for a particular Job number AND those that are protected by law), BUT i want it to preference my company data over someone elses.
The query is needed to complete a "likelihood of occurrence" assessment of all protected species. Therefore it is vitally important that our records are selected before anyone elses, because then i know it was "Recorded" in our study area, rather than being someone elses record, which means the species can only be assessed as "Likely" or "Possible".
If i leave in the field that differentiates my data from someone elses, then i will not get a truly unique/distinct recordset.