Easy and Stupid Question But.......

[Spawny]

Hi,

I am having a problem with my database. It seems to be rounding up numbers. I have the field in the database as a number with 2 decimal places. If I enter in 7.6 it rounds it up to 8. How can I fix this?

Thanks in advance.

Mike

[JHausmann]

What database are you using?

[jcouture100]

Hi,

You'll be happy to know that it's simple to fix. When you define your field as a number, the default type is Long Integer (look at the Field Size). An integer doesn't have any decimal places so it rounds the number you enter. To fix this, change the Number type (field size) to either Single or Double, depending on your needs.

Hope this helps.

[Spawny]

It's an Access Database.

Thanks Jcouture100 as this has solved the problem.

Mike

[hlieu]

and also set the format to FIXED