how to enter data with decimal places

[richard999]

I am new to databases. I have set up a simple database but when I enter say 14.75 as a number the database converts it to 15.00. I am not aware of having set any rounding conditions.



Help appreciated!

[June7]

Probably need to change the number type property of the field in table to Double instead of Single.

[ItsMe]

It is interresting that you are displaying 15.00. Without formatting, you will not typicaly see the zeros. A single or Double or Currency data type will manage decimals.

I will guess you have an integer data type truncating the value somewhere. It could even be at the table level. How big of a number are you trying to store in your table and how many decimal places do you need? What is the range of values?