how to extract certain text in a field

K

kevin

Hi,

I am trying to figure out how to select the last three digits of a field to
run a query and dont know how.

EX; 001-001 (i want to select the last three digits)
 
K

kevin

Thank you very much for your assistance

Allen Browne said:
The right-most 3 characters in Field1 would be:
Right([Field1],3)

--
Allen Browne - Microsoft MVP. Perth, Western Australia.

Reply to group, rather than allenbrowne at mvps dot org.

kevin said:
I am trying to figure out how to select the last three digits of a field
to
run a query and dont know how.

EX; 001-001 (i want to select the last three digits)
Click to expand...
Click to expand...
 
Top