Calc Sugestion Please

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Best Way to set up fields in table 4
Subquery Correllated In Select Clause - Is this possible? 3
Concatenation as a default value rather than in a query 2
Pricing from a table based on dimesions in 2 differnt cells (Excel 3
No Chart Titles 1
Wrong Answer concatenating fields 6
Why do I get #NUM! for a GEOMEAN calc on a set of positive vals 14
Insert picture, resize to specific width, keeping height proportio 7

Top