Member Avatar for dreamer_lek91

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=)

  • 2 Contributors
  • 1 Reply
  • 358 Views
  • 1 Week Discussion Span
  • Latest Post Latest Post by boblarson
Member Avatar for boblarson

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.

Edited by boblarson because: n/a
Be a part of the DaniWeb community

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