daverskully
Registered User.
- Local time
- Today, 11:36
- Joined
- Mar 10, 2008
- Messages
- 23
Form created with buttons that prompt a query that opens a report based on specific criteria. I am looking to create a specific query with the details listed below.
Relevant Fields:
Department
ReportDate (recorded on the date when the report/record is entered)
I am looking to have a query created (or any method in which this can be done, always open to suggestions) so that it generates reports, based on information derived from one table, for all of the last entered records for each specific department. I am looking to have reports created for the last reporting date of each department (100 of them, currently) so that 100 of the latest records are showing (one record for each department based on last date).
It would be amazing if this can be done, I've been having a great deal of trouble with it. If you require any further information please ask, I will usually respond very quickly. Thank you in advance.
Relevant Fields:
Department
ReportDate (recorded on the date when the report/record is entered)
I am looking to have a query created (or any method in which this can be done, always open to suggestions) so that it generates reports, based on information derived from one table, for all of the last entered records for each specific department. I am looking to have reports created for the last reporting date of each department (100 of them, currently) so that 100 of the latest records are showing (one record for each department based on last date).
It would be amazing if this can be done, I've been having a great deal of trouble with it. If you require any further information please ask, I will usually respond very quickly. Thank you in advance.