I need help with applying dates . . . .
I need to export Access reports to file using today's() date off the system for auditing purposes. However, if the report was run previously and is rerun, the date updates. So I need a solution to applying the date that the report was first run and then stopping that date from updating.
Same goes for forms too - a default date value for the data entry day which does not update. A joined date which becomes static after reading off system.
Also, how do you export a report and append today's date to its filename? New at this, thanks for any help.