Is there a way to remove duplicates from a report based on a single field in the report? I know I can set it to not include uniques on a single query but the problem is this report uses a Union Query made up of about 10 queries and some records hit more than 1 of these queries so they are showing up on the report multiple times. One field in each record is different based on the query it came from (a text box is filled out with information depending on which query its from).