Rounding unwanted 1

[bubba100]

We have a database that is rounding and not sure why. Entering a number directly into the field of the table anything less than 100,000 is recorded correctly(99,999.99 is recorded that way). While anything greater than 100,000 is rounded to the first decimal place (100,000.01 is recorded as 100,000.00). The data type of the filed is Number, field size is Single, Format is Standard and decimal places are 2.

Thanks in advance for any ideas on my error.

 

[Remou]

You are exceeding the size of the single data type, you may wish to look at currency or double.

http://lessthandot.com

 

[bubba100]

Remou- thanks. Looks like it is time to go back to school.