I'm using this as the control source for a field on a form. It work fine to give me the last (max) date on the field.
But in another field on the form I need to provide the record just prior to the Max record.
Here is my code for the Max record:
=DMax("[Discharge Date]","ER Visit","[EmpID] = " & [Forms]![frmEmpMaster]![txtEmpID])
How do I code to get the record before the max record?