Union Query, duplicates

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Mark Baker - 14 Nov 2007 21:50 GMT

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.

Reply to this Message

Wolfgang Kais - 15 Nov 2007 12:49 GMT

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.

Signature

Regards,
Wolfgang

Reply to this Message