Hello!!
I have a field "Course" with data like:
AAA 210
AAA 210A
AAAA 300
AAAA 300A
AA 250
AA 250A
AAAAA 300
AAAAA 300X
I am doing:
Mid([tablename]![Course],InStr([tablename]![Course]," ")+1,3) to get just 3 numbers after the space.
what I am getting:
AAA 210-->2
AAA 210A-->2
AAAA 300-->30...