Help!

Extracting numbers

  
  
Post new topic   General Reply to Topic (not reply to a specific post)    Forums Home -> Getting Started RSS
Next:  Using Templates  
Author Message
Hendrix
External


Since: Sep 24, 2009
Posts: 1
PostPosted: Thu Sep 24, 2009 2:07 pm    Post subject: Extracting numbers
Archived from groups: microsoft>public>access>gettingstarted (more info?)
I have a field with 9 numbers and I would like to extract the last 5.
(ie 123456789 to 6789) Is that possible?
Back to top
KARL DEWEY
External


Since: Mar 03, 2006
Posts: 1616
PostPosted: Thu Sep 24, 2009 2:33 pm    Post subject: RE: Extracting numbers [Login to view extended thread Info.]
Archived from groups: per prev. post (more info?)
Your example shows last 4, not 5.
Try --
New_Field: Right([Old_Field], 5)
--
Build a little, test a little.


"Hendrix" wrote:

> I have a field with 9 numbers and I would like to extract the last 5.
> (ie 123456789 to 6789) Is that possible?
>
Back to top
Display posts from previous:   
Post new topic   General Reply to Topic (not reply to a specific post)    Forums Home -> Getting Started All times are: Eastern Time (US & Canada) (change)
Page 1 of 1

 
 You can post new topics in this forum
You can reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum