how to extract certain text in a field

[Guest]

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)

 

[Allen Browne]

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

 

[Guest]

Thank you very much for your assistance

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.

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)