Issue with fixed decimal positions in calculations of qry

[MEMFBI]

Hello


I have an update qry to a table with a field named GASCST defined as Number/Double/Fixed/3 decimal places.
When I view table the field displays as .001, but when I click on the field it displays as .00057. I need to use this field in later calculations to be .001, but in the later calculations it is using .00057.
How can I keep this field at .001?

Data example:
MGCP10 = .3 VOLP00 = 19
GASCST=((Round([MGCP10]/100,3)*[VOLP00]/100)) displays .001 but when used in the next calculation it is using .0.00057

Thank you








Thank you

[davegri]

Try rounding the result instead of just one multiplier.

GASCST=Round([MGCP10]/100*[VOLP00]/100,3)

[MEMFBI]

Perfect.
How simple

Thank you

[davegri]

Glad to help. Good luck with the project!