split string of numbers and remove leading zeros 1

[tamnet]

I have an access db that is linked to a legacy system, one of the fields in the table has a string of 24 numers such as

008902920089019703650197

every four numbers represent a measure in millimetres i.e. the above string would be

0089
0292
0089
0197
0365
0197

I have managed to split the string into 6 seperate fields using the Left and Mid functions but I also want to remove the leading zeros so that the numbers would end up so

89
292
89
197
365
197

I would like to know if this is even possible ??

Any help would be appreciated



Regards

Paul

 

[PHV]

Have a look at the Val (or Int) function:
Val(Left([yourField],4))

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886

 

[tamnet]

PHV,
Thank You "VAL" worked fine

[


Regards

Paul