How do i get all the entries in three columns of an access table .

[Guest]

I want to creat a single column list of all the entries in three colums of
the access table. I don't need to delete duplicates (if there are any) from
the three columns. All I want is just have one column which is cumulative of
the three columns in the access sheet.

Is this possible?

 

[Van T. Dinh]

Use a Union Query with SQL String Like:

SELECT Field1 FROM YourTable
UNION ALL
SELECT Field2 FROM YourTable
UNION ALL
SELECT Field3 FROM YourTable

OTOH, the needs of queries similar to the above often indicate that the
database may be unnormalised. Have you checked that your database is
properly normalised?

 

[Guest]

An easy way without code is to create first create your new table with the
NewField then an Append Query. Pick your old table and Field1 to append to
the NewField, run the query, then change to Field2 to append to the NewField
and so on.

Hope this helps.