Display on Report

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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?
 
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")
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Back
Top