Splitting a data field

G

Guest

I have a 5-character data field that I would like to split into a filed
containing characters 1 and 2, and a second field containing characters 3
thru 5. Can't figure it out - help greatly appreciated.
 
G

Guest

You can use 2 calculated field to do this.

FirstPart: Left([SomeField],2)
LastPart: Right([SomeField],3)
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Split data in field on character return 0
Help on zero field 1
Splitting fields in access 2010 0
How do I validate a field has 5 characters (alphanumeric)? 4
Split column contents (de-concantenate) 7
splitting data in a query 3
Delete any record with an alpha in a field 4
Splitting a Field 1

Top