Is there any way in SQL to run a query and weed out all the duplicates from the result so that you are only left with unique records. Can this be based on one of the fields of the record for the checking part? I have a query that produces a number of results and its drawing them from multiple tables with the same fields in each table, and some of the records and duplicates that i would like to ignore in my report. Anyone know a way? I am using Access.