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")
 
Back
Top