Question regarding decimal points

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

Guest

How do i set up to display one or more decimals on a field without Access
rounding it off? I went to the design view in my form and my field is
specified as a Number type, Long Integer field size, the Format is "General
Number" and i specified 1 decimal point. However, when I go to my table and I
try to enter the value of 8.9 for axample, Access rounds it off to 9.0. What
should I do?

Thanks,
 
Change the datatype from Long Integer (an Integer is a whole number with 0
decimal places!) to something like Single, Double or Currency.
 
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 stripping decimal places in query 1
0 Decimal places/round function. 4
Query Calculation Decimal Point Removal 7
Displaying digits after the decimal point 5
Access keeps rounding down... Decimal 5
Decimals In Access 4
Decimal Points 3
Stop Rounding in Forms 2

Back
Top