If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
|
#1
|
|||
|
|||
Making 2 colums into one
I have an excel file that I imported into Access. There are 5 fields.
Item 1-5 The item names are in column 1 and column 3. I need to combine the two columns in to just one column. Can this be done? Thanks for your help and reply. -- Message posted via AccessMonster.com http://www.accessmonster.com/Uwe/For...esign/201006/1 |
#2
|
|||
|
|||
Making 2 colums into one
Use a calculated field --
Combined: [column 1] & " - " & [column 3] Or omit the dash and use one space or comma and a space as you wish it to be displayed. You could add a new field in your table and run an update query but that is probably not a good idea as it is always harder to split data when needed than to combine as above for display. -- Build a little, test a little. "Afrosheen via AccessMonster.com" wrote: I have an excel file that I imported into Access. There are 5 fields. Item 1-5 The item names are in column 1 and column 3. I need to combine the two columns in to just one column. Can this be done? Thanks for your help and reply. -- Message posted via AccessMonster.com http://www.accessmonster.com/Uwe/For...esign/201006/1 . |
#3
|
|||
|
|||
Making 2 colums into one
Thanks Karl. That worked perfectly.
KARL DEWEY wrote: Use a calculated field -- Combined: [column 1] & " - " & [column 3] Or omit the dash and use one space or comma and a space as you wish it to be displayed. You could add a new field in your table and run an update query but that is probably not a good idea as it is always harder to split data when needed than to combine as above for display. I have an excel file that I imported into Access. There are 5 fields. Item 1-5 The item names are in column 1 and column 3. I need to combine the two columns in to just one column. Can this be done? Thanks for your help and reply. -- Message posted via http://www.accessmonster.com |
Thread Tools | |
Display Modes | |
|
|