I can't enter numbers right of the decimal.

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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?
 
You cannot use an Integer and have decimals. Change you number to Single in
your table design.

Hope this helps.
 
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.
 
Back
Top