Hello!!
I have a field "Course" with data like:AAA 210A
AAA 210
AAAA 300
AAAA 300A
AA 250
AA 250A
I am doing:
Mid([tablename]![Course],InStr([tablename]![Course]," ")+1,3) to get just 3 numbers after the space.
This is not giving me those three numbers..Please help!!!
Thanks in advance:-)