Show Unique Values on a Union Query?

  • Thread starter Thread starter Anne
  • Start date Start date
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.
 
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).
 
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.
 
Back
Top