I am trying to use the InStrRev function in a query and am getting the error message:
"Undefined function 'InStrRev' in expression."
I have a field in a table that contains student register marks as a continuous string.
/ - attended
O - absent
From this string I am trying to find the first and last attendance mark.
To find the first I am using:
which works fine.
To find the last I thought I would be able to use:
but, although I have followed the syntax advice in the help file it doesnot seem to work.