Difficult mathematic 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

 

[KARL DEWEY]

Try this --
CalLBS: IIF([Cubic feet]*50>=[ Pounds], [Pounds],â€â€)

CalCF: IIF([Cubic feet]*50>=[ Pounds], [Cubic feet],â€â€)

 

[Levans digital]

HI KARL THANKS FOR YOUR ASSISTANCE.
I TRIED YOUR SOLUTION BUT FOR THE POUNDS FORMULA ACCESS IS ASKING FOR A
"POUNDS" VALUE TO BE NETERED ITS IS ALSO ASKING FOR A "" VALUE TO BE ENTERED.
THE ABOVE ACCURS ALSO FOR THE CUBICFEET FORMULA.

WHAT DO YOU THINK?

Try this --
CalLBS: IIF([Cubic feet]*50>=[ Pounds], [Pounds],â€â€)

CalCF: IIF([Cubic feet]*50>=[ Pounds], [Cubic feet],â€â€)

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

 

[KARL DEWEY]

I now see a space inside the left bracket.

Try re-typing the double quotes, I sometime have problems on double quotes
when going from Word to Access.

HI KARL THANKS FOR YOUR ASSISTANCE.
I TRIED YOUR SOLUTION BUT FOR THE POUNDS FORMULA ACCESS IS ASKING FOR A
"POUNDS" VALUE TO BE NETERED ITS IS ALSO ASKING FOR A "" VALUE TO BE ENTERED.
THE ABOVE ACCURS ALSO FOR THE CUBICFEET FORMULA.

WHAT DO YOU THINK?

Try this --
CalLBS: IIF([Cubic feet]*50>=[ Pounds], [Pounds],â€â€)

CalCF: IIF([Cubic feet]*50>=[ Pounds], [Cubic feet],â€â€)

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