OfficeFrustration

OfficeFrustration (http://www.officefrustration.com/index.php)
-   Database Design (http://www.officefrustration.com/forumdisplay.php?f=27)
-   -   Making 2 colums into one (http://www.officefrustration.com/showthread.php?t=1119348)

Afrosheen via AccessMonster.com June 3rd, 2010 10:03 PM

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


KARL DEWEY June 3rd, 2010 11:52 PM

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

.


Afrosheen via AccessMonster.com June 4th, 2010 02:29 PM

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



All times are GMT +1. The time now is 08:41 PM.

Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2018, Jelsoft Enterprises Ltd.
OfficeFrustration.com