S
SJ
I want to create something that tracks and records the date every time I run
a report. This will mean creating a new record every time the report is ran.
Right now, I have two tables: "tblReports" which identifies the report and
assigns an id (ReportID - Primary key) and name (ReportName) to each report
along with a description. I also have a table called tblRunHistory
containing HistoryID, ReportID and ReportName, and a date field called
LastRanDate. I want to have a record for every time each report was ran.
There are too many reports to try and remember so I need to have the report
id and name show and have a field to enter new dates.
Anyone have any suggestions how this can be accomplished?
Thanks very much in advance.
SJ
a report. This will mean creating a new record every time the report is ran.
Right now, I have two tables: "tblReports" which identifies the report and
assigns an id (ReportID - Primary key) and name (ReportName) to each report
along with a description. I also have a table called tblRunHistory
containing HistoryID, ReportID and ReportName, and a date field called
LastRanDate. I want to have a record for every time each report was ran.
There are too many reports to try and remember so I need to have the report
id and name show and have a field to enter new dates.
Anyone have any suggestions how this can be accomplished?
Thanks very much in advance.
SJ