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

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

Matching Invoice Number 1
Picking up last 4 letters from a field 2
Remove Certain String from Query Field 6
extract 3 numbers from a string 0
Adding a prefix number 2
Moving the last numbers of a field 3
Joining fields without using prefix 2
Moving the last numbers of a field 3

Back
Top