Finding Latest Date

[RC-]

How can I find the latest date in a table and then add it to a report?

Thanks,
RC-

 

[RC-]

Nevermind, I figured that one out too.

Thanks,

 

[John Vinson]

How can I find the latest date in a table and then add it to a report?

Thanks,
RC-

Set the Control Source of a textbox on the report to

=DMax("[datefield]", "[tablename]")

using the actual names of the field and table.

John W. Vinson[MVP]