Converting

C

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
 
T

Tom Lake

Chris said:
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
Click to expand...

Divide the number by 100.

Tom Lake
 
J

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
 
Top