Difficult Mathematical Calculations

[Levans digital]

I need some serious help please coders!!!
I have 4 fields as listed below.
Keep in Mind 1 Cubic Feet = 50 pounds

Pounds (Number field)
Cubic Feet (Number field)
Calculated pounds (Calculated field)
Caculated cubicfeet (Calculated Field)

The form would look like this

Pounds Cubic feet CalLBS CalCF
50 1 50
200 3 200
150 5 5

Here is what I want to accomplish with my cargo Management Database.
Ex in Line 1. When 50lbs is entered and 1 cubic feet is entered both values
are equal so I want the pounds results be reflected in the calculated pounds
field.

Ex in Line 2. When 200lbs is entered and 3 cubic feet is entered. Logically
200 pounds is greater than 3 cubic feet (3 cubic feet x 50 would equal only
150lbs) therefore again the results must be reflected in the calculated
pounds field.

Ex in Line 3. When 150lbs is entered and 5 cubic feet is entered. Logically
5 cubic feet is greater than 150LBS (5cubic feet x 50 would equal 250LBS)
Therefore now would the greater value be reflected in the calculated cubic
feet field.

I hope you can understand my explanation thanks.
Please Help

 

[Rick B]

STOP POSTING THIS. You have now posted this same question at least five
times.

Someone will answer you. No need to keep posting over and over in multiple
newsgroups.

http://www.mvps.org/access/netiquette.htm