reporting high and low value

[Brad_(Guest)]

If I have a numeric field and would like to report on the high value and low value of that field in the database, how would I proceed. I was thinking about an IIF, however, I am not sure that would work.____Example____23__43__12__62__98__12__3__45__94__22____I would like to have a report:____High 98__Low 3____You help is appreciated.

[kfleming]

You just need two totals. One is a minimum of the field and the other a maximum of the field.____Kathleen__R&R Support