Coding for Textbox to retrieve maxdate 1

[jminn0311]

Can anyone help me with some coding for a textbox in the header of my report that would return the maxdate of the records from the query on which the report is generated? Sorry about the run on sentence! Thank you.

 

[dhookom]

Control Source: =Max([Your Date Field Here])

Duane
Hook'D on Access
MS Access MVP

 

[jminn0311]

Thanks for the reply. Your advise is appreciated! I used something a little different to format it.
=Format(DMax("DateOfIncident","qryIncidentInvestigationReport"),"yyyy")

 

[dhookom]

DMax() creates another recordset which is not efficient. I wasn't aware you were looking for only the year. I typically open reports with a where condition. The DMax() expression may return the wrong results.

If you want the year only and don't want the inefficiency of another query against your database and want a guaranteed accurate result, use:

=Year(Max([DateOfIncident]))

Duane
Hook'D on Access
MS Access MVP