Display on Report

Y

yblong

ON MS Access, how do I show highest value on Report? I know how to do that on
Query, but I only want to produce, for example, the highest invoice amount
for a list customers, how do I go about it on the report design?
 
S

Steve Huff

Well if you know how to do it in a query why not just bound the report to
that query? Or you could use the DMAX function on a text box. Something
like:

=DMAX("fieldname","Table/QueryName")
 
Top