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

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





More information about the AccessD mailing list