field calculation rounding off

[woodpecker]

I have 2 number fields that hold 2 decimal places and when I enter 3.33 is rounds to 3 I don't want it to round because when I multiply the end result is not correct How can can I make it so that these field don't round?

[ranman256]

Extend the decimals, then truncate is you need.
In the query filed property, set Format,fixed,2

or in the field:
Format(field,"0.000")

[davegri]

Make sure your table does NOT define the fields as Long Integer or Integer. Those formats are whole numbers only.