max

[mboe]

I have make two copies of a database at the end of every month. One gets archived and the other goes into an end of month folder which gets copied over every month. I run a bunch of reports at the end of everymonth.

I need to put the "as of" date, meaning the last day of that month on the report. I tried pulling a date out of one of my tables with =max([tablename]![last_transaction]) but it only works on reports with that tabel as the source.

Is there a way to get all reports to pull the say data field with max or is there a better way to get the last day of the month on the report?

 

[mboe]

No takers.....well here is what I figured out.

First I setup a query for the max of the field that had the dates in it. Then I created a report based on that query. I then added that report as a subreport wherever I needed that data. Not perfect but it works. Had to play with appearance a little.