split a data field in access

M

midnitewizard

I am trying to spilt a data field into 2 fields from a table. Basically, the
original field has a 7 digit number in it, and I want to separate this 7
digit number into 2 fields. One field containing the first 3 digits, and the
other field containing the last 4 digits.

Version is Access 2003.
 

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

How to Create an S-Curve from Custom Field? 0
Delete all data after a symbol in a field 0
Need some PWA help 0
Page numbering with Merged Document and IF statements 1
Autonumber field in Excel that behaves the same as Access 0
Finding the proper style field and the numbered paragraph value within the style 0
Copy previous record into form field 0
Finding the right style field in VBA 0

Top