Splitting Field

Diggsy · December 11th, 2005, 04:26 PM posted to microsoft.public.access.tablesdbdesign

I have a db that has over 220k entries. My problem is that I one field is
very long called SKU descr. Ity has 8 numbers a space and anywhere form 20 to
30 characters after. Is it possible to split this field in 2 and call the
numbers SKU ID and have the rest of the text stay in SKU description.

Thank you,

Chris

Douglas J. Steele · December 11th, 2005, 04:43 PM posted to microsoft.public.access.tablesdbdesign

To get the first 8 characters, use the Left function. To get whatever starts
at position 10 and goes to the end, use the Mid function:

Left(CompleteString, 8) and Mid(CompleteString, 10)

--
Doug Steele, Microsoft Access MVP
http://I.Am/DougSteele
(no e-mails, please!)

"Diggsy" wrote in message
...
I have a db that has over 220k entries. My problem is that I one field is
very long called SKU descr. Ity has 8 numbers a space and anywhere form 20
to
30 characters after. Is it possible to split this field in 2 and call the
numbers SKU ID and have the rest of the text stay in SKU description.

Thank you,

Chris

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Form, Subform, Tab key	2nd_Stage_User	Using Forms	17	August 25th, 2006 12:30 AM
Enter text in a field and have it appear as entered elsewhere	Gregory Winters	General Discussion	6	November 1st, 2005 02:09 AM
Splitting Text Field	sfcwarren	Running & Setting Up Queries	1	March 7th, 2005 06:22 PM
Splitting a field	David#	Running & Setting Up Queries	2	February 28th, 2005 03:19 PM
field manipulation	Steve	Running & Setting Up Queries	2	May 28th, 2004 03:12 PM