Retrieving the most recent date in a recordset

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.
 
F

fredg

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