Retrieving the last 4 numbers of a 9 digit field.

  • Thread starter Thread starter The Chomp
  • Start date Start date
T

The Chomp

Good Day;

I am trying to build a query that will only select the last 4 numbers of a
9 digit field. Example : From 123456789 I would get 6789.

Thanks

Chomp
 
Thanks Douglas.......

Douglas J. Steele said:
Right([NineDigitNumber], 4)

--
Doug Steele, Microsoft Access MVP

(no private e-mails, please)


The Chomp said:
Good Day;

I am trying to build a query that will only select the last 4 numbers of a
9 digit field. Example : From 123456789 I would get 6789.

Thanks

Chomp
Click to expand...
Click to expand...
 
Back
Top