Union Query Question

[Guest]

Hello,

Im trying to do a Union Query (?) to combine multiple tables within a Access
database. Each table holds different mailing lists for my agency. We are
using Access because it is a powerful program -lthough my tables are
non-relational.

How can I make the Union Query delete duplicates from the tables when it
combines them all? Or should I do a Select Query?

Thanks in advance for any help. ;-)

 

[Guest]

Quote from the Access Help:

By default, no duplicate records are returned when you use a UNION
operation; however, you can include the ALL predicate to ensure that all
records are returned. This also makes the query run faster.

Look for UNION Operation in the Help for details.

Good Luck!