cansevin
asked on
Number with a decimal
I feel like a fool for asking this... but I have a field in a form and everytime I hit, 4.5 it comes up as "4"... how do I make it so it stays the same? I have checked everything I can think of.
Attached is the database. The fields are "Total Hours" and "Duration"... please explain so I can fix it in the future.
Thanks!
Chris
Attached is the database. The fields are "Total Hours" and "Duration"... please explain so I can fix it in the future.
Thanks!
Chris
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
change the Field size to double
Oh ... and same for Duration in the Appointments table.
mx
mx
see image
Capture1.gif
Capture1.gif
Unless you need more than 4 decimal places I find that the Currency data type is actually better and more accurate in precision than single or double.
Since the OP is apparently dealing with Hours, Single with two decimal places is more than sufficient, having a decimal precision of 7 places.
Both Double and Currency take up 8 bytes to store, whereas Single takes only 4 bytes.
mx
Both Double and Currency take up 8 bytes to store, whereas Single takes only 4 bytes.
mx
ASKER
PracticeMdb.mdb