Thanks for the help on my other question for my report! It is working beautifully because of all the help everyone provided me with.
One more question - how do I make a text box on a report have the date/time a file was last updated?
My situation is I have a file called grades.csv that is exported from our main database (file structure is saved so every column always contains the same data) and I have a linked table that goes to that CSV file. As users export from our main system, they save on top of the grades.csv file, thus the data reporting on is updated. What I want to add to my access report is a textbox that provides the date that grades.csv was last updated so as a user runs the report, they know they are using the most up to date version of data. And if they see an old date, it reminds them that they forgot to export the data before running the report.
I can't seem to figure out how to do this. I was hoping to just be able to refer to a file "Last Changed" date from the file property, but that doesn't seem to be an option in the properties.
One more question - how do I make a text box on a report have the date/time a file was last updated?
My situation is I have a file called grades.csv that is exported from our main database (file structure is saved so every column always contains the same data) and I have a linked table that goes to that CSV file. As users export from our main system, they save on top of the grades.csv file, thus the data reporting on is updated. What I want to add to my access report is a textbox that provides the date that grades.csv was last updated so as a user runs the report, they know they are using the most up to date version of data. And if they see an old date, it reminds them that they forgot to export the data before running the report.
I can't seem to figure out how to do this. I was hoping to just be able to refer to a file "Last Changed" date from the file property, but that doesn't seem to be an option in the properties.