Query For Many Most Recent Dates

[Nick]

I have a list of reports and each report has many "processes" in it. I tried
to use some information that I found on this site to print off the "Most
Recent Completion Date", it was givin by Duane Hookom:

Group your report by ReportName with a group header. Sort next by
MostRecentCompletionDate
Descending. Add a text box to your report's detail section:
Name: txtCount
Control Source: =1
Running Sum: Over Group
Visible: No
Add code to the On Format event of the detail section:
Cancel = Me.txtCount>1

This works perfect except that it only brings up the most recent date for
only the report and not each of its processes. So, to sum up, I am being
given the most recently completed process and I need the most recent
completion date for EACH of the processes. Thanks in advance for any help!

 

[KARL DEWEY]

Open you report in design view, click on menu VIEW - Grouping and Sorting and
add the "process" field.