how to trim a numeric value?

[eeps24]

I have tons of values for example...



043401792930179293000000000000
486934620469284720452458733452
548065110164648465132013541355

I only want to keep the values in red. 2nd, 3rd and forth columns of each value. Is there some sort of Trim I can do?

[JoeM]

Are your entries actually a Number or Text Data Type?
I ask because your first entry has a leading zero. The only way a leading zero will be displayed is if:
- the entry is actually Text and not numeric
- it a number with some Custom Formatting

Whether it is Text or Numeric will determine how we need to approach your question.
If it is Text, we can just use the MID function, i.e.:
MID([MyField],2,3)

[eeps24]

they are numeric values.

[JoeM]

You should be able to use the FORMAT function along with the same Custom Formatting you have applied to this field to coerce that numeric entry to a text entry, and then you can use the Text formula I provided previously on it.

[eeps24]

how would I use the format function? Do you mean like a from up on top of FORMAT as code value?

[JoeM]

What is the Custom Format you are using on that number to get the leading zero to show?

[eeps24]

I am not sure, all i did was run a pretty much basic query and that result came in just like that. I didnt do anything else to it.

[June7]

Numbers don't have leading zeros. What is the field type the value is stored in? That many digits, Access will insist on scientific notation when it displays the value in a number type field.

If the field is text type, try the expression suggested by JoeM.