Combine two columns from two tables into on column using a query.

[0243906]

Im trying to query two tables together which have almost the same information except for one column of information. In the query i want to get a list of all information in the two tables and leave out the columns that i don't need. My problem is how do i combine two columns from two different tables (but with same info and column heading) into one single column using a query.

 

[Remou]

Hi
If you mean into one long column, you could look at a Union query.

 

[PHV]

Have a look at the concatenation operator &:
SELECT Table1.FieldX & ' ' & Table2.FieldY AS CombinedInfo

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886

 

[0243906]

Hey thanks a million its workinf for me now ya saved me alot of time and effort.