Converting

[Chris]

If I have a feild that has the number 54200 in it how can I trim off the 00
so I end up with 542? When I try the the left function I get the results I
want but it converts the data type from a number to a text feild. I need to
keep this feild a number data type. Any sugestions?

Thanks,
Chris

 

[Tom Lake]

If I have a feild that has the number 54200 in it how can I trim off the
00 so I end up with 542? When I try the the left function I get the
results I want but it converts the data type from a number to a text
feild. I need to keep this feild a number data type. Any sugestions?

Thanks,
Chris

Divide the number by 100.

Tom Lake

 

[Chris]

Thanks so much Tom. I can't believe I didn't think of that.

 

[John Spencer]

54200\100 will return 542
54200 / 100 will return 542
Val(Left(54200,3)) will return 542

54220\100 will return 542
54220/100 will return 542.2
Val(Left(54200,3)) will return 542

755411 \ 100 will return 7554
Val(Left(755411,3)) will return 755