DMax used in form

[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

 

[Duane Hookom]

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

 

[Guest]

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.