Create a query of unique references from three tables

[ellisellis]

I import three tables that all contain a UniquRef. I want to be able to create a query that gives me all of the UniqueRef's from all of the three tables in one column then grouped so as to have just one instance.

I have tried to create (created querys to get my three tables down to one column of UniqueRefs) a New Table using UNION but I am then unable to query this New Table to group the resultant UniqueRef.

Can you point me in the right direction, I feel Im perhaps approaching this all wrong

As always, your patience and advice is greatly received.

[ellisellis]

Many thanks speedramps. Have a great weekend, I will......now !!

[speedramps · Accepted solution]

Please try this solution, click the thumbs just for me helping you and click solved if it fixes your problems. Cheers !

• Go into edit mode by clicking on Home > Transform Date >Transform Data
• Click Append Queries >Append Queries as new> Three or more tables > and then add all 3 Available tables to Tables to append.
• In the new table, right click the Ref column > Remove other columns.
• In the new table, right click the Ref column > Remove duplicates.
• Voila ... you now have a unqiue list of Refs.

There are other ways to answer your problem, but the trick here is to use Append and Remove Duplicates, rather than Group.