Numbers round up?

H

HeatherLou1974

When creating my database, I made one field a "number" field. When I put in
41.5, it rounded up.
Aside from making it a text field, I couldn't get the field to stop rounding
up.
Anyone else have this problem and find a way to make it stop?
Thanks!
 
A

Allen Browne

Open the table in design view, and select the Number field.

In the lower pane, set the Field Size to:
Double

The integer types can only store whole numbers.
 
H

HeatherLou1974

I need it to reflect 1/2 hours, which is why I made it a text field.
I have also just found out that if it IS a text field, that I can't get the
fields to add.
Is there any way around either of these problems?
 
Top