I've done my homework, I think

TVReplay99

Registered User.
Local time
Today, 16:30
Joined
Jan 2, 2002
Messages
29
Yes this is another Stock/Inventory question but not the usual. I have read about 300 posts on Stock DB and agree that calculating the Items in stock# is the best way.

My question is after a few year or 100,000 transactions how ould one go about purging old transactions or making a historical file?

I would think this action would throw off the accurate calcuations.
would a table that holds Year End Stock totals be an answer?

If this subject has been covered previously, my apologies and I will continue my search.

Thanks to all that read.

Brian
 
One way is to create an archive table of old transactions and an intermediate table with the count of the the archived transactions. Then when computing current values, build a union query the intermediate table and your active inventory table.
 

Users who are viewing this thread

Back
Top Bottom