Is there an easier way to select the Max of two calculations 1

[NeilT123]

I have the following IIF statement in one of my queries. The query works and returns the expected results but I wondered if there was an easier way to return the max of two values rather than using the two IIF statements below or any suggestions on how to make this query more efficient?

TotalNAppliedByOM: Round(Sum(IIf([UseInRegCalculations]=Yes,([OMApplicationRate]*[NValueFarmersOwn]),
(IIf([tblCropping].[CroppingYear]<2011,
IIf([NValueFarmersOwn]>[NValue7thRB209],([OMApplicationRate]*[NValueFarmersOwn]),([OMApplicationRate]*[NValue7thRB209])),
IIf([NValueFarmersOwn]>[NValue8thRB209],([OMApplicationRate]*[NValueFarmersOwn]),([OMApplicationRate]*[NValue8thRB209])))))))

Thank you for any suggestions

 

[PHV]

A little simpler:

TotalNAppliedByOM: Round(Sum(OMApplicationRate*IIf(UseInRegCalculations=Yes,NValueFarmersOwn,
IIf(tblCropping.CroppingYear<2011,
IIf(NValueFarmersOwn>NValue7thRB209,NValueFarmersOwn,NValue7thRB209),
IIf(NValueFarmersOwn>NValue8thRB209,NValueFarmersOwn,NValue8thRB209)))))

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886

 

[NeilT123]

Thanks PHV, I know that the change that you suggest is only on one small query but it is having the different view that I appreciate. I would never have thought about simplifying things by moving the common factor of "OMApplicationRate*" to the "outside" of the statement. It will be something I will consider with other statements. Thanks again.