expression - choose a larger field

[statechamp171]

I am a newbie when i comes to ACCESS so bear with me. I want to make a field with an expression that chooses the larger value between 2 other fields. Example:



Field: Bench Press 1 (BP1)

Field: Bench Press 2 (BP2)

Field: Bench Press 3 (BP3)

Field: Bench Press Difference (BPD)

So I want the expression to do the following: BPD = BP3 - (which ever is greater BP1 or BP2)

I hope that makes sense: Please Help!!!

[isladogs]

Use an IIf statement

BPD=BP3-IIf(BP2>BP1,BP2,BP1)

[statechamp171]

Worked liked a charm!!!! Thank You.

[isladogs]

You're welcome. Easier for me than doing bench presses.

[Micron]

Just so you are aware going forward - it's generally considered bad practice to store calculations or have calculated table fields. I can't tell where I want to make a field is supposed to exist, so forgive and ignore me for jumping in if it's only in a query, form or report that you're doing this.