Retrieving the most recent date in a recordset

  • Thread starter Thread starter MDY
  • Start date Start date
M

MDY

I want to create a field in a form that searches the
recordset of a related table and returns the value of the
most recent date entered in a given field.
 
I want to create a field in a form that searches the
recordset of a related table and returns the value of the
most recent date entered in a given field.
Click to expand...

In an unbound text control:
=DMax("[DateField]","TableName")
 
You must log in or register to reply here.

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

Similar Threads

Recordsets-Old and New 5
Creating Checkbox Fields For Every Record 0
Filter or reload recordset? 4
Sort on date field 1
Filter main form to records with no related records in subform,maintain updateable recordset 4
populate form with a recordset 3
Form does not show recordset's data 6
Recordset for Form with a subform 2

Back
Top