Numbers rounding?

  • Thread starter Thread starter Dennis
  • Start date Start date
D

Dennis

In my table, on my forms, and in my querys all of the
numbers I use in the hours field and other fields round to
whole numbers? Example I input 90.24 and get 90. I am
using this in a payroll application and unstead of using
minutes ie 60= 1 hour, I use 100th's ie 100= 1 hour. In
my table the hours field's properties are Number, Long
Interger, and fixed. How can I make access Not round and
use exactly what I input?

Thanks Dennis
 
You would need to change the data type to double or single or decimal as
Long Integers are integers (whole numbers).
 
Thank You Duane, that worked perfectly.

Dennis
-----Original Message-----
You would need to change the data type to double or single or decimal as
Long Integers are integers (whole numbers).

--
Duane Hookom
MS Access MVP





.
Click to expand...
 
Back
Top