access

  • Thread starter Thread starter Padideh
  • Start date Start date
P

Padideh

HI,i'm trying to have the decimal option on my access how should i have it?
right now whatever number that i enter ,the access will round it up to the
higher or lower amount(like:14.56 will show as 15),
would you help me how can i have the decimal numbers on my access?
 
Check the number type. It sounds like your table has the field defined as
an "integer" (whole number).

Regards

Jeff Boyce
Microsoft Office/Access MVP
 
HI,i'm trying to have the decimal option on my access how should i have it?
right now whatever number that i enter ,the access will round it up to the
higher or lower amount(like:14.56 will show as 15),
would you help me how can i have the decimal numbers on my access?
Click to expand...

The default Number datatype (if you don't specify otherwise) is Long Integer;
and an Integer is by definition a whole number.

There are other types of Number. Open the table in design view and select this
field; look at its properties in the box at the lower left. The first box lets
you select Integer, Long Integer (whole number again), Single, Double, or
Decimal. The three latter will let you enter decimals.

Or, if this field refers to money data, consider not using a Number datatype
at all, but instead use a Currency datatype. It gives you four (no more, no
fewer, though you can set the format to *display* fewer) decimals, and does
not have the possible roundoff error problems of the Float or Double
datatypes.
 
Back
Top