Can a variable be added to a table field? 1

[08211987]

Hi,
I have a very large set of tables that I want to start storing the total number of records for each table into a weekly row in a table so that I can compare from week to week to make sure the numbers seem correct. They ultimately export to reports but I want to add some summarized validations.

Currently I am storing the number of records for each division in variables and displaying them on a email that is sent to me when the job finishes. Is there a way to store those variables in a table? I would also store the current date and append a row each week. Then I will also use another tool to bring in those history records each week for also size trending. My first thought is to create a form that contains each field and then just save the form adding the record.

Just curious if there is a better way?

Thanks!

 

[MajP]

Just create a "log" table. Then weekly run an insert query into that log.

 

[08211987]

Good idea, thanks!