Find the last date in a table

[kidkosmo]

I have a table which contains incoming call metrics by date which is
imported from another application. For example:

IM12345 6:13 AM 10/14/2008
IM12346 6:24 AM 10/14/2008
IM12347 6:20 AM 10/15/2008
IM12348 6:25 AM 10/15/2008

Is there a "simple" way for the to display on a form the last date for
the data in this table. I only want to show that date once to let
people know at what date the data cuts off.

Thanks!

 

[Jeff Boyce]

"Last" is a relative term.

What Access means by "Last" and what you (probably) mean by "Last" probably
don't match.

Try a Totals query and use the Maximum (rather than the Last).

Regards

Jeff Boyce
Microsoft Office/Access MVP

 

[John Spencer]

On a form, you could set a control's source to

= DMax("TheDateField","TheTableName")

That is the simplest thing I can think of. It would not update
automatically while the form was open, but if you closed the form or
forced a recalculation it should update.

'====================================================
John Spencer
Access MVP 2002-2005, 2007
Center for Health Program Development and Management
University of Maryland Baltimore County
'====================================================