numbers

  • Thread starter Thread starter chris morrison
  • Start date Start date
C

chris morrison

This is going to sound really stupid, but I cannot get
percentages to enter in my access table. I cannot put in
95%, or .95, or any decimal or percent lower than 100. It
either changes to 9500.00%, or changes to 0, or 1. What
the heck is going on? Please take pity on someone who
should know better. Thanks in advance, Chris.
 
Change the number type in your table from Integer to Single or Double as
appropriate for the accuracy you need.

--
Regards,

Adrian Jansen
J & K MicroSystems
Microcomputer solutions for industrial control
 
Chris,

In the design of your table, check the FieldSize of your number field. It
sounds like you are using the default FieldSize of Long. If you will change
that to Single or Double, you can enter decimal values such as .95
 
Back
Top