Mid Question perhaps?

[sdc1234]

Greetings, I am having difficulties with this: I have a column with students and teacher combined 14(25)2(represents 14 students, 25 class seats and 2 teachers, I am tring to pull the 25 seats out into a seperate column on my querry. any ides?



V/R
novice

[pbaldy]

Presuming the number of characters can vary, you can use the Mid() function along with the InStr() and InStrRev() functions to find the opening and closing parentheses.

[Xipooo]

Heh.. pbaldy... I know John Galt

[June7]

Why is this data combined into one field anyway? Store in separate fields. Concatenation is easier than splitting.

[sdc1234]

Presuming the number of characters can vary, you can use the Mid() function along with the InStr() and InStrRev() functions to find the opening and closing parentheses.

can you give me an example please

[sdc1234]

Why is this data combined into one field anyway? Store in separate fields. Concatenation is easier than splitting.

Agreed, But I do not produce the original RAW Data....

[June7]

Val(Mid(x, InStr(x, "(") + 1))

Use field name in place of x.

Access Help (or search web) has more info on string manipulation functions.

[sdc1234]

that worked thanks I appreciate it