Dima
05-21-2002, 10:06 PM
In a query, I need to get the third digit of a student ID. Is there any way to do that?
|
View Full Version : Get the third digit of a number Dima 05-21-2002, 10:06 PM In a query, I need to get the third digit of a student ID. Is there any way to do that? ColinEssex 05-21-2002, 11:25 PM Mid([StudentID],3,1) Col tomv 05-23-2002, 03:28 AM But first make sure it's at least 3 digits long! Better might be: Iif(len(StudentID)<3," ",mid(StudentID,1,3)) |