• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 2465
  • Last Modified:

Access 2007 auto rounding up number in table

i have a field in a table that is set to the Number data type, how can i stop it from rounding up when i enter 1.5 as the number?

the field size is set to Integer and the decimal places property is set to 1
0
TSTechNA
Asked:
TSTechNA
1 Solution
 
peter57rCommented:
Integer = Whole Number

You need to use Double.
0
 
TSTechNAAuthor Commented:
thank you
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Ultimate Tool Kit for Technology Solution Provider

Broken down into practical pointers and step-by-step instructions, the IT Service Excellence Tool Kit delivers expert advice for technology solution providers. Get your free copy now.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now