lets say that the employe number is standard at 6 char. long
to look up the last one in a query grid select the column employee number
do a mid on the column
mid(employee_num,6,1) (thats mid starting at the 6th place going one place)
then in the criteria put in the value that you want to search for
ie the number 6
I think you can put Right([employee], 1)...
Depend on what do you want as a result. On the query grid, just use the new column, put field: Right([employee], 1), and put criteria: 6, (or whatever value), then uncheck the "show" unless you want another field that display the last digit. Usually, access will move the unshow field to the right.
I think Right([employee], 1) will not produce any error, and not too complex, provided [employee] is the correct field name to look up... and you are very sure there is no chance of null's...
The criteria should be a text: i.e "6", not just 6...