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...
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Access stripping decimal places in query 1
Cant eliminate decimals in a query 1
Decimal format 3
Format query result as Data Type Number, Field Size Decimal 3
How do I get Access to append the exact amount with decimals? 2
Export number without decimals 1
Implied Decimal Point 3
formula for decimal point 4

Back
Top