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...
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Extracting numbers 1
Adding a record number field 3
1 Field into two this one is tricky 4
Removing duplicate characters in text field and arranging characte 6
Zip Code Last 4 Digit as Zero 1
Extracting numbers 6
make one phone number field by appending 3 together? 2
Removing duplicate characters from a word and rearranging it 2

Back
Top