Form / field properties

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

Guest

I want to have a mark-up field for calculation the mark-up of my products,
every time I enter 1.4 the system rounds the number to 1, 1.5 rounds to 2.
How do I stop this? I want to maintain the number that I input.
 
I want to have a mark-up field for calculation the mark-up of my products,
every time I enter 1.4 the system rounds the number to 1, 1.5 rounds to 2.
How do I stop this? I want to maintain the number that I input.
Click to expand...

Most likely the field in the table is a Number datatype, Integer or
Long Integer field size.
By definition an Integer is a whole number. Therefore it cannot have a
decimal value.

Change the Field size to either double or single, or change the
field's datatype to Currency.
 
I want to have a mark-up field for calculation the mark-up of my products,
every time I enter 1.4 the system rounds the number to 1, 1.5 rounds to 2.
How do I stop this? I want to maintain the number that I input.
Click to expand...

I'd guess you're using the default Number datatype, which is Long Integer.
integers are by definition whole numbers.

Change the type of the number (in the field properties in the lower left of
the table design window) to Float, Double, or Decimal; or change the datatype
from Number to Currency. I'd recommend the latter if the prices you're marking
up are Currency datatype; that datatype allows four (no more, no fewer)
decimals.

John W. Vinson [MVP]
 
Back
Top