S
Scot Dever
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.
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.