I'm trying to create a query that lists all telephone numbers in one column. I have three telephone fields in one table and would essentially like to take these three fields and Chang and together on one list.
I have tried the union command but without success; I'm assuming this command is only used to join separate tables and not fields within the same table.

Much appreciated

Macky

Try with:

Select <field 1> from <table> as <Alias>
UNION Select <field 2> from <table>
UNION Select <field 3> from <table>

Regards,
Antonio

Doesn't seem to work, I should be getting 25823 records, but only getting 25093...

UNION command automatically delete duplicated records.
If you want all records use 'UNION ALL' and not 'UNION'.

Regards,
Antonio

Perfect. That saves me the effort of the next step in the process of cleaning and preparing the list!

Many thanks!