Show Unique Values on a Union Query?

A

Anne

Is this possible? Without the query grid I don't get this
option. Can I write in in SQL?

Thanks in advance for your assistance.
 
B

Brian Camire

By default, UNION queries return only unique records (that is, in a similar
way as SELECT DISTINCT or, equivalently, queries with the value of the
"Unique Values" property set to Yes).
 
T

tom

Try writing the Union query as two queries and join them together with the
word UNION... (removing the first semicolon). This will allow you to setup
each query on the grid before joining them and losing that facility...

HTH.

Tom.
 
Top