Page 1 of 1

reporting high and low value

Posted: Mon Aug 29, 2005 10:57 pm
by 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.

=> RE: reporting high and low value

Posted: Tue Aug 30, 2005 8:59 am
by 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