Solved need help tabel field

[shobhanauto]

hi all i try whole day to fix this issue
when i set values 0.69 its back to 1 automatic
any expert help me please?

 

[Gasman]

You are not showing dutyrate?

 

[Pat Hartman]

Have you looked at the data type? If it is integer, .69 will be rounded to 1. You need to use either single or double precision or preferably the Currency data type if you don't need more than four decimal places of precision.

 

[The_Doc_Man]

Pat, it would appear from the middle of the 3 screenshots (Screenshot_31) that dutyrate IS a Double specified with 2 places and therefore should handle a number such as 0.69 correctly. I agree that the result LOOKS like there was something going on with integer math, but we might have to look a little closer to see from where it occurs.

 

[Pat Hartman]

The column shown as a value of 1 isn't the column shown in design view. Also, There could be a format on the query that is altering what is displayed.