In a query, I need to get the third digit of a student ID. Is there any way to do that?
D Dima New member Local time Today, 04:12 Joined May 13, 2002 Messages 9 May 22, 2002 #1 In a query, I need to get the third digit of a student ID. Is there any way to do that?
ColinEssex Old registered user Local time Today, 04:12 Joined Feb 22, 2002 Messages 9,118 May 22, 2002 #2 Mid([StudentID],3,1) Col
T tomv Guest May 23, 2002 #3 But first make sure it's at least 3 digits long! Better might be: Iif(len(StudentID)<3," ",mid(StudentID,1,3))
But first make sure it's at least 3 digits long! Better might be: Iif(len(StudentID)<3," ",mid(StudentID,1,3))