Union Query, duplicates

[Mark Baker]

I have used a union query to bring together 2 select queries, however I would
like to delete duplicates on the basis of 1 field only. Is there a way of
specifying the criteria for dealing with duplicates? I would also need to
tell it which query gets priority.

 

[Wolfgang Kais]

Hello Mark.

I have used a union query to bring together 2 select queries,
however I would like to delete duplicates on the basis of 1 field
only. Is there a way of specifying the criteria for dealing with
duplicates? I would also need to tell it which query gets priority.

Union queries do not support this.
But you can make it a union all query, add a field for the priority
and use this query as the source for a query that does the filtering.