Format of column changes mid-database

[CYAEGER]

I have a column in an Access 10 database that is a percentage and displayed as, for example, 95.45%. At the beginning of the database when I entered 95.45 it would display as 95.45%. Hundreds of rows later the same column changes format. When I enter 95.45 it is displayed as 9545.00%. In order to have it displayed properly I have to move the decimal to the left 2 places to get it to display properly. In other words I have to enter .9545 to get 95.45%.



My question is: why would this change in the middle of a database? and how do I correct the problem?

[June7]

I never use the Percentage and Currency settings in table. I have seen some weird issues associated with them but this is weirdest.

I would just set as Double and format for percent or currency display in form and report.

If you want to provide db for analysis, follow instructions at bottom of my post.

[DrGUI]

Try this:

Update TableName set PctVal = PctVal / 100 where PctVal > 1