Picking up last 4 letters from a field

  • Thread starter Thread starter CAM
  • Start date Start date
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
 
SELECT Right(AccountNumber, 4) As NewField FROM SomeTable

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