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
Who is Participating?
peter57rConnect With a Mentor Commented:
Integer = Whole Number

You need to use Double.
TSTechNAAuthor Commented:
thank you
All Courses

From novice to tech pro — start learning today.