Web Development

Ask something
Discussion Locked

Access 2000 String Manipulation

0 helpful
2 replies

by mra2

Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.

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

2 replies

by dryflies

use the MID function
variant = mid(field,position,length)
you can use the expression builder to create the expression for each digit.
mid(table!boardnumber,1,1)
mid(table!boardnumber,2,1) etc.
please rate my answer

This discussion is closed to new replies.