S
soareagle
can i split an existing field in Access table? ie, the opposite of
concatenation. how?
concatenation. how?
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
G
Golfinray
Bring the table into a query. Select the half of the fields that you want in
the first table. Make that query into a make-table query. Run it and make
table 1. Repeat for table 2.
the first table. Make that query into a make-table query. Run it and make
table 1. Repeat for table 2.
S
schasteen
yes, there are fuctions such as left and right and other ways to get just a
portion of the value. Some sample data and results would help you to get
better suggestions.
portion of the value. Some sample data and results would help you to get
better suggestions.
L
Lynn Trapp
can i split an existing field in Access table? ie, the opposite of
concatenation. how?
Do a search on the Right(), Left(), and Mid() functions in help.
Lynn Trapp
www.ltcomputerdesigns.com
T
Tom Wickerath
In addition to using the Left, Mid & Right functions, you can export your
table to Excel, and use Data > Text to Columns... to split it up, based on
some identifier, such as a comma, space, tab, etc. You can also use the
built-in Split function to split data into an array. I show a few examples on
pages 6 and 7 of a Word document that I call "Access Links.doc". You are
welcome to download a zipped copy from my web site:
http://www.accessmvp.com/TWickerath/
Tom Wickerath
Microsoft Access MVP
http://www.accessmvp.com/TWickerath/
http://www.access.qbuilt.com/html/expert_contributors.html
__________________________________________
table to Excel, and use Data > Text to Columns... to split it up, based on
some identifier, such as a comma, space, tab, etc. You can also use the
built-in Split function to split data into an array. I show a few examples on
pages 6 and 7 of a Word document that I call "Access Links.doc". You are
welcome to download a zipped copy from my web site:
http://www.accessmvp.com/TWickerath/
Tom Wickerath
Microsoft Access MVP
http://www.accessmvp.com/TWickerath/
http://www.access.qbuilt.com/html/expert_contributors.html
__________________________________________