I have these few dates in my database and I would like to have the latest date to be shown at my report footer.

03 dec 2001
15 may 2010
08 mar 2007
14 jan 2004
29 sep 2009

can any kind soul plz help me?=) thx alot in advance=)

Control Source of the text box:

=DMax("YourDateFieldNameHere", "YourTableNameHere")

Replace YourDateFieldNameHere with your actual field which has the dates and YourTableNameHere with the name of the table where the date field resides. And KEEP THE DOUBLE QUOTES.

Be a part of the DaniWeb community

We're a friendly, industry-focused community of 1.21 million developers, IT pros, digital marketers, and technology enthusiasts learning and sharing knowledge.