Pickup numbers from a field

  • Thread starter Thread starter CAM
  • Start date Start date
C

CAM

Hello,

I have a field that has 12 digits - Example AS0090040101. What I want to do
is to pick up only the number 9004 and put it into another field in my
query. How do I do that? Any tips will be apperciated. Thank you.


Cheers
 
hi,
I have a field that has 12 digits - Example AS0090040101. What I want
to do is to pick up only the number 9004 and put it into another field
in my query. How do I do that? Any tips will be apperciated. Thank you.
Click to expand...
When your field is not null you can use this in a query:

MyNumber: Mid([fieldName], 5, 4)



mfG
--> stefan <--
 
Thanks Stefan I appreciate the help.
Cheers

Stefan Hoffmann said:
hi,
I have a field that has 12 digits - Example AS0090040101. What I want to
do is to pick up only the number 9004 and put it into another field in my
query. How do I do that? Any tips will be apperciated. Thank you.
Click to expand...
When your field is not null you can use this in a query:

MyNumber: Mid([fieldName], 5, 4)



mfG
--> stefan <--
Click to expand...
 
Back
Top