History Table and Data

I have created one table holding a variety of date fields including original
and current date fields. But what I also need is a monthly history of those
dates either on the first of the month, end of the month or perhaps even a
command button letting the user copy the table information as of that date
over to the history table. I can then have monthly record of what each date
field contained for comparison and creation of a report/query. Is there a
way to create a table to do this and how to I trigger the data copy properly.

Why not just keep a record of whenever a date changes in your database?

Have a date set table, something like:
RecordID
TypeOfDate
Date
DateSet

If you take a complete copy, you will be storing lots of data that has not
even changed.

--
"Give someone a fish and they eat for a day; teach someone to fish and they
eat for a lifetime".


"Scot Dever" wrote:

I have created one table holding a variety of date fields including original
and current date fields. But what I also need is a monthly history of those
dates either on the first of the month, end of the month or perhaps even a
command button letting the user copy the table information as of that date
over to the history table. I can then have monthly record of what each date
field contained for comparison and creation of a report/query. Is there a
way to create a table to do this and how to I trigger the data copy properly.