Report Experts Wanted

[Bruce D.]

Hi all,
I have 3 different field names on a report. Lets say they are called web
price, phone price, and catalog price. I also have a total field. My dilemma
is what kind of expression would I use in the total field to determine the
lowest or minimum of the 3 price fields. Can this be accomplished with an
expression or would this be more of a function. Any help would be greatly
appreciated.

B.D

 

[Sprinks]

The Min and Max functions supplied with Access only work in the aggregate
(i.e., an entire recordset). The following link includes custom functions
for the min and max of a passed array.

http://www.tek-tips.com/faqs.cfm?fid=2333

Hope that helps.
Sprinks