How do I enter Percents in Access?

P

paul

A real simple database to track students and test scores and other misc data.
But no matter how many times I check the Database and form properties to
ensure decimals are set to zero, or two, I keep getting the wrong percent
show up on the form. ie: 69% shows up as 6900% when decimal is set to two;
and as 100% when decimal is set to zero or auto. I have tried entering .69;
69.00; .0069... all to no avail. any help would ease my passing!!! :p
 
J

John W. Vinson

A real simple database to track students and test scores and other misc data.
But no matter how many times I check the Database and form properties to
ensure decimals are set to zero, or two, I keep getting the wrong percent
show up on the form. ie: 69% shows up as 6900% when decimal is set to two;
and as 100% when decimal is set to zero or auto. I have tried entering .69;
69.00; .0069... all to no avail. any help would ease my passing!!! :p
Click to expand...

Sounds like you are using the default Long Integer datatype for the field. An
Integer, by definition, is a whole number.

If you instead use a Single or Double Float number datatype, then 0.69 will
display as 69% (they are just two ways of depicting the same value). You can
enter this in a textbox by either typing .69 or by typing 69%; entering 69
will display as 6900.

John W. Vinson [MVP]
 
Top