A
Anne
Hi Sheryl:
Do you want the last updated in the entire table, or only
in the records included in the report?
If you want the last one in the entire table put a new
text box anywhere on your report with this formula:
=dmax("FieldName", "TableName")
If you want just the last date from the records included
in the report, then you can put a new textbox in the
report header or footer that says =max(FieldName).
If you want it on the footer of every page though, you'll
have to do a trick because Max wont work in the page
footer. Here's what to do in that case: put the textbox
=max(FieldName) in the detail band and name it something,
say txtMaxDate, then in the footer put a text box
=txtMaxDate.
Do you want the last updated in the entire table, or only
in the records included in the report?
If you want the last one in the entire table put a new
text box anywhere on your report with this formula:
=dmax("FieldName", "TableName")
If you want just the last date from the records included
in the report, then you can put a new textbox in the
report header or footer that says =max(FieldName).
If you want it on the footer of every page though, you'll
have to do a trick because Max wont work in the page
footer. Here's what to do in that case: put the textbox
=max(FieldName) in the detail band and name it something,
say txtMaxDate, then in the footer put a text box
=txtMaxDate.