I need to show the date of the table that the information is coming from on all of my reports. The only thing is, is that when a new table is brought into the database this data has to change to show the new date of the information. I have the dates of the policies which I tried using the max to get the date of the last info before the table was used in the database which would effectively be the data with which the info came from but in certain queries and reports the max isn't the same date due to sorting and filtering of other information. It also didn't work for crosstab queries. Do you know anyway I can show the data of the table was created on a report without having to mess with queries and alter the data already represented in anyway? Any other suggestions would be greatly appreciated. Thanks.
date of information
- Thread starter User Name
- Start date
