calculate the minimum value of 4 controls

[JasonM]

I know this is a bit of an odd request, but I would like to calculate the
minimum of four distinct values on a report.

I have four fields for each daily record: I1, I2, I3 and I4 there is a value
for each day and I would like to be able to flag the lowest value of the
four for each day on the report.

I have tried a nested iif statement, but that got pretty ugly, and it only
evaluated to the first correct statement... I was hoping to just use a
calculated field without creating a query just for this purpose...

Is this what I am going to have to do? is there a way that I can just do
this in the control on the form? or in the base query?

Any assistance would be appreciated.

Thanks, Jasonm

 

[JasonM]

I figured this one out... I had to impliment a bit of VBA, but my solution
worked quite well. Not nearly as troublesome as I first thought.

Thanks for looking in, and if you are trying to do something similar, give
me a jingle and I will email you the code that I used.

Jm