General discussion

Locked

Access 2000 String Manipulation

By MRA2 ·
I have a field called BOARDNUMBER on a form which is TEXT Length 6.
The present value of the field is 123456. I want to break the field into 6 seperate digits.
Digit #1 = 1 Digit # 2 = 2 Digit # 3 = 3
Digit #4 = 4 Digit # 5 = 5 Digit # 6 = 6

I tried the Left & Right functions but they give me multiple digits.

Can anyone out there help me?

Thanks!
Alan
New York City

This conversation is currently closed to new comments.

2 total posts (Page 1 of 1)  
| Thread display: Collapse - | Expand +

All Comments

Back to Web Development Forum
2 total posts (Page 1 of 1)  

Related Discussions

Related Forums