Historical Data

[DS]

How do you set-up tables with historical data. I have an order-entry
database where at the end of the day I want the data to go to a table
storing the old infomation.
Thank You
DS

 

[Guest]

hi,
an append query which would append orders in the order
entry table to the history table.
you did not say anything about clearing the order entry
table but if you did want a clean table each morning, you
could have a delete query to do that.
you could attach both to a button to click at the end of
the day or attach them to the on close event of the main
entry form.

 

[Rick B]

Personally, I would not move records around like that. Why add that
maintenance and risk losing a record? If there is a date in the record, you
can include or exclude records based on the date. If your forms and reports
are based on a query, then you would be able to filter out the old records.

Rick B

 

[DS]

Personally, I would not move records around like that. Why add that
maintenance and risk losing a record? If there is a date in the record, you
can include or exclude records based on the date. If your forms and reports
are based on a query, then you would be able to filter out the old records.

Rick B

I was trying to archieve them so I could back them up and then remove
them from the system so that the database doesn't become bloated. Am I
barking up the wrong tree...again? Is there a way to do this?
Thanks
DS

 

[DS]

hi,
an append query which would append orders in the order
entry table to the history table.
you did not say anything about clearing the order entry
table but if you did want a clean table each morning, you
could have a delete query to do that.
you could attach both to a button to click at the end of
the day or attach them to the on close event of the main
entry form.




go to a table

Thanks, I'll give this a try.
DS