Bob Gajewski
rbgajewski at adelphia.net
Tue Jun 1 13:38:26 CDT 2004
Gary Use the DMax() function. Bob Gajewski -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com]On Behalf Of Boehm, Gary D. Sent: Tuesday, June 01, 2004 13:46 To: Access Developers discussion and problem solving Subject: [AccessD] Show Most Recent Date in Section Header (cross-posted) I've created a 3 column report with one of the columns being "review date". What I'd like to do is grab the most recent review date and place it in the section header. In the example below, I'd like to pull 5/7/04 (the most recent review date)and place it in the section header. Any suggestions? Due_Date Description Review_Date <--Page Header John Doe Incident Date: 2/2/04 <--Section Header 1/2/05 testing 5/5/04 <--Data 1/3/05 testing123 5/6/04 1/4/05 testing456 5/7/04 Access 2002 SP-2 Gary Boehm -- _______________________________________________ AccessD mailing list AccessD at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/accessd Website: http://www.databaseadvisors.com