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
