Access Table

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

Guest

Can someone please confirm the Field property in a table for fixing the
STORED value of a curreny value to 2 decimal places.

Many thanks

Simon
 
There is no property that controls the number of decimal digits STORED for
the Currency data type. The DecimalPlaces property defines what is
DISPLAYED. Try using the Decimal data type. I think it may allow you to
define the digits stored.
 
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 database sum calculation error 0
Access stripping decimal places in query 1
Decimal places in forms and tables 5
Stop Rounding in Forms 2
Can't seem to quit Access from rounding numbers 3
How to get 2 digit decimal when data is 13 og ikke 13,00 1
Problems With Precision while Linking Tables 4
Data type enforcement error 5

Back
Top