Access Rounded All the Prices In My DB Up

[LearningAndEarning]

Major Issue. Access rounded all the dollar amounts up to the next dollar in the DB I am working on for a bookstore. Anyone know how and why it would do this. Are there any solutions to getting my prices back without having to go in and chage all 1300 records?

Thanks

 

[traingamer]

What did you do to make it do that?

(You may need to restore from a backup depending on the answer to the above).

Greg
"Personally, I am always ready to learn, although I do not always like being taught." - Winston Churchill

 

[LearningAndEarning]

I am not aware of anything I might have done. I am still pretty new to Access so I might not have realized I had done something. Then there is also the dreaded someone in the office with less knowledge about Access than myself tinkering with the db.

Can you suggest any possible things I might have done?

 

[traingamer]

What are the data type / format / decimal places for this field in your table design? It is possible that someone changed something there (without changing the underlying data).

Greg
"Personally, I am always ready to learn, although I do not always like being taught." - Winston Churchill

 

[LearningAndEarning]

The data type is Currency, Format is currency, and the decimal places are 2. What happened was bascially any book that was say $6.95 is now $7.00 the decimal place stayed the same and the format just the price was rounded up. I'm just looking for an easy way to change back if possible. I have added new records since this problem developed and these prices have stayed at the amounts I entered them in as.

The original records were imported from Excel, but they imported correctly. I am not sure when the prices changed, my boss noticed it on a report I made for her.

Devin