UNION removes duplicates by default.

What you may find is that you will not be able to use the default connection
method in Word 2002/2003 (OLEDB) to connect to a UNION query. You may be
able to work around that by
a. wrapping the UNION query up in yet another query (I don't know for sure)
b. changing the connection method (check Word Tools|Options|General|Confirm
conversions at open, and choose ODBC or DDE when prompted. There are side
effects.

Peter Jamieson

"prismlight" wrote in message
...
Thanks everyone,

So now I understand that I can NOT select more then one file or table
within
Access and that I need to use a Union (or select) Query to combine
records.

My only question is how to do a Union Query that will delete duplicates?

thanks

ps. maybe this should be posted in Query section? sorry im new to this

"prismlight" wrote:

Hi
Im at step 3 - Select Recipients.
Use an existing list-Browse.
It will only allow me to pick ONE file at a time.

Is there an easy way to select more then one file at a time?

thanks in advance