Union Query, duplicates

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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.
 
Hello Mark.

Mark said:
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.
Click to expand...

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.
 
Back
Top