Displaying Last Date in Report Footer

[JDubs]

This is probably an easy fix, but I can't get it to work.

I have a table (tableName) that includes a last modified column. Currently
I have forms setup to modify the date of LastMod any time that record is
modified.

LastMod Col1 Col2 Col3

A report displays a query of Col1 and Col2 from tableName. In the Report
Footer I want to put the most recent LastMod date/time. Currently I have a
query that finds the right time, but I can't get the report to display it.
Using a text box, I have the Record Source as:

=[query].[LastMod]

in the Report Footer, but when I go to Report View, a box prompts me to
enter the value for [query].[LastMod]. I think I'm doing it right, but there
must be something simple I'm missing. Any help would be greatly appreciated.

 

[Marshall Barton]

This is probably an easy fix, but I can't get it to work.

I have a table (tableName) that includes a last modified column. Currently
I have forms setup to modify the date of LastMod any time that record is
modified.

LastMod Col1 Col2 Col3

A report displays a query of Col1 and Col2 from tableName. In the Report
Footer I want to put the most recent LastMod date/time. Currently I have a
query that finds the right time, but I can't get the report to display it.
Using a text box, I have the Record Source as:

I think all you need to do is add the LastMod field to the
report's rexord source query. Then the report footer rwext
box can use the expression:
=Max(LastMod)

 

[Klatuu]

Use a DMax function.

=DMax("[LastMod]", "TableName",???)

Where ??? is the criteria to filter the function.