Query to move decimal point to the left

  • Thread starter Thread starter bob bonehead
  • Start date Start date
B

bob bonehead

Hello everyone,

I need a query to move a decimal point to the left 2 spaces. I have a
database created by another company and in the cost field they are not using
a decimal place. $2.59 in there database looks like this 259 without any
decimals. How can I fix this problem?

Thanks

Dunnie
 
Divide by 100?

SomeField/100
And to really force it I might wrap that in a CCur function

CCur(SomeField/100)
 
Thanks John,

Fixed me right up.

Dunnie

John Spencer (MVP) said:
Divide by 100?

SomeField/100
And to really force it I might wrap that in a CCur function

CCur(SomeField/100)
Click to expand...
 
Back
Top