Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
Discussion GroupsFormsForms ProgrammingQueriesModules / DAO / VBAReports / PrintingMacrosDatabase DesignSecurityConversionImporting / LinkingSQL Server / ADPMultiuser / NetworkingReplicationSetup / ConfigurationDeveloper ToolkitsActiveX ControlsNew UsersGeneral 1General 2
Access DirectoryToolsTutorialsUser Groups
Related Topics
SQL ServerOther DB ProductsMS OfficeMore Topics ...

MS Access Forum / Forms / July 2007

Tip: Looking for answers? Try searching our database.

Query For Many Most Recent Dates

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
Nick - 12 Jul 2007 19:34 GMT
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 - 12 Jul 2007 20:08 GMT
Open you report in design view, click on menu VIEW - Grouping and Sorting and
add the "process" field.
Signature

KARL DEWEY
Build a little - Test a little

> 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
[quoted text clipped - 14 lines]
> 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!
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2009 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.