Join Columns

[yippie_ky_yay]

Hello,

I'd like to be able to create a query to select all entries from columnA and columnB both from Table1 and put the result in columnX (a temporary column) while keeping it RecordID. So the result should be two columns (ColumnX and RecordID).

Any guidance would be greatly appreciated!

Thanks,

-Sean

 

[jfgambit]

Open a new Query, add the RecordID field, in the next field type the following:

ColumnComb: [NameofColumnA] & [NameofColumnB]

Run the Query

 

[yippie_ky_yay]

Thanks for answering jfgambit!

Re-reading my original post I see that I didn't exactly explain it too clearly (sorry!).

What I need is to have column A "on top" of column B. So if my table was:

RecordID ColumnA ColumnB
1--------- Toast-----Jam
2--------- Bread----Butter

The result from a query that I'm looking for would give me:

RecordID ColumnX
1--------- Toast
1--------- Jam
2--------- Bread
2--------- Butter

Thanks again,

-Sean

 

[Rich]

I think a Union Query is the closest you'll get

 

[yippie_ky_yay]

Thanks Rich - that sure did the trick! I've even done union queries before - I don't know why I didn't remember!

-Sean