Why does Access round currency when I enter an item's price?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I use Access to keep track of quotations the company provides, but whenever I
enter in any money values, it automatically rounds the cents down to zero.
Obviously, I need to have those cents show up there.
 
johnstonp said:
I use Access to keep track of quotations the company provides, but
whenever I enter in any money values, it automatically rounds the
cents down to zero. Obviously, I need to have those cents show up
there.

What DataType are you using? Sounds like you are using Number/Integer or
Number/Long Integer when you need to be using Currency.
 

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

Back
Top