DATABASE CURRENCY FIELD

  • Thread starter Thread starter DecypherEncrypted
  • Start date Start date
D

DecypherEncrypted

We use a program a work that enters all of our information on billing
clients into a database. You choose a service and the fee is
automatically entered into the field according to the service. Most of
our fees end with .50. Such as $3.50. When we choose the service, the
fee always comes up as $4.00 instead of the $3.50 that its suppose come
up as. How can I edit this field to always show the correct ammount and
not round it up to $4.00 ?
 
We use a program a work that enters all of our information on billing
clients into a database. You choose a service and the fee is
automatically entered into the field according to the service. Most of
our fees end with .50. Such as $3.50. When we choose the service, the
fee always comes up as $4.00 instead of the $3.50 that its suppose come
up as. How can I edit this field to always show the correct ammount and
not round it up to $4.00 ?
Click to expand...

The usual problem with something like this is that the field datatype
is Number with field size Integer or Long Integer. By definition, an
integer is a whole number.
Change the field datatype to Currency.

You can also set the field datatype to Number ... field size Double.
 
It is already set at Currency.
Click to expand...

What is set at Currency?
The table Field's datatype property or the table field's Format
property?
They're different.

Also check that the field's Decimal Places property is set to 2 or
Auto, and that there is no code in the form changing the control's
value.
 
Back
Top