DMax used in form

  • Thread starter Thread starter Scott
  • Start date Start date
S

Scott

I have a form linked with a query that have two parameter query fields to
filter required records. After entered the parameters, I would like to
select the maximum number of the third field using DMax function. How can I
make reference to the form or query instead of table. I need to find out
the maximum number of selected records instead of all records. Your advice
is appreciated.

Thanks,

Scott
 
"I would like to select" doesn't provide much meaning (at least to me). If
you want to display the maximum value of a field from your form's record
source, just add a text box to the form header or footer with a control
source like:
=Max([YourThirdFieldName])
 
Look in tht Northwind sample database shipped with Access at the Orders from
and Orders sub form. It has a good example of sub totaling and totaling.
 
Back
Top