Calculation based on cubic foot

[dmon2010]

I have a form that shows Length, width, height and weight.



I have the form set up like this:

Length x width x height / 1728 = cubic feet

Weight / cubic feet = lbs per cubic foot


Now I want to add another field that will give me one of three answers, depending on the lbs per cubic foot.

under 22.5 lbs per cubic foot = 70
22.6 - 30 lbs per cubic foot = 65
31 and over lbs per cubic foot = 60

Not sure if I need to create a query to get this right.

Any help would be greatly appreciated!

[NTC]

this is called a calculated field and is performed in a query using an IIF

you will already have 1 calculated field which would be this: CubicFt: (Length x width x height) / 1728

your new calc field I will call 'Find'.... Find: Iif([CubicFt]<22.5,70,0)

bing/goggle IIF to see that syntax and you'll see that this results in 70 or 0 .... then you get to nest those in order to 3 way (or more...)

[ItsMe]

I would consider VBA if you plan on using Single Form view. Use an alias in a query if you plan to view the data in DS view.