I can't enter numbers right of the decimal.

H

hotdoxy

I am entering hours and fractions of hours using a form to enter data into a
table in access. Both the form and the table are formatted to show two
digits to the right of the decimal. When I enter a decimal of an hour, the
decimal is dropped. I am using Long intger, fixed with two decimal places.
How can I fix this?
 
J

Jackie L

You cannot use an Integer and have decimals. Change you number to Single in
your table design.

Hope this helps.
 
H

hotdoxy

Jackie L said:
You cannot use an Integer and have decimals. Change you number to Single in
your table design.

Hope this helps.
Click to expand...
Thanks, I knew it would be something simple that isn't covered in the books.
 
Top