[AccessD] Show Most Recent Date in Section Header (cross-posted)

Boehm, Gary D. gdb at AllenandAllen.com
Tue Jun 1 12:45:38 CDT 2004


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



More information about the AccessD mailing list