automatic historical archive of data to be referenced

[deltauser2006]

My database consists of information which is updated every quarter.
Forms will compare data from the present quarter to quarters past. I
need a way to make the database save a copy of itself every quarter and

then be able to have a form refer to that data through a comparison.
The historical data set would be created at the end of each quarter and

lock in all the values from that quarter. For example this quarter
(1st quarter 2006) I would need to refer to 1st quarter 2005 for a
comparison. Obviously a set of data for 1st quarter 2005 hasn't been
created yet so I would have to put data in manually but eventually once

the data was populated I would want it to do the comparison
automatically.

I realize this is an involved problem but if anyone could just give me
a general suggestion to get me moving in the right direction I would
really be grateful!!

 

[Guest]

Forms will compare data from the present quarter to quarters past.
Forms do no compare - queries can compare and then form display.

If you are dating your records there is no need to save a copy. In your
query use a second instance of the same table. It will be indicated the the
table name followed by underscore one like -- MyTable_1