C
Chaster
I am creating a new table and will be doing caluclation based on 3 fields
[length], [width], [height]
I originaly set these up as numbers longinteger 0 decmial places.
Went back and changed them to number, double, 0 decmial places.
My calculation would be ([length]*[width]*[height])/250
when my fields = (48*51*43)/250 it returns a value of 96099.84
when I do this on my calculator it returns the value of 421.0560 (This value
is correct)
My questions are:
What would be the best way to set up my fields in the table?
Double, Integer, etc, etc
Whats wrong with the above calculation that it does not return the correct
value?
TIA
[length], [width], [height]
I originaly set these up as numbers longinteger 0 decmial places.
Went back and changed them to number, double, 0 decmial places.
My calculation would be ([length]*[width]*[height])/250
when my fields = (48*51*43)/250 it returns a value of 96099.84
when I do this on my calculator it returns the value of 421.0560 (This value
is correct)
My questions are:
What would be the best way to set up my fields in the table?
Double, Integer, etc, etc
Whats wrong with the above calculation that it does not return the correct
value?
TIA