Picking up last 4 letters from a field

C

CAM

In my query I have an account account number that I only want to pick the
last 4 letters. The account number has 8 numbers and text. This field is
actually a text field. For example account number will be 11AS6792 I only
want to get "6792" How do I do that. Thank you in advance.

Cheers
 
G

Graham R Seach

SELECT Right(AccountNumber, 4) As NewField FROM SomeTable

Regards,
Graham R Seach
Microsoft Access MVP
Sydney, Australia
 
Top