bluenoser337
Programmer
I have a single Access '97 table collecting about 10,000 records a day. These records represent manufactured parts. At the end of the day, after printing a report giving the full parts listing for the day, I would like to summarize the data (many parts have exactly the same characteristics) and add it to a "summarized table". This table could then be queried with a "date range" search, etc to report "old" information without having to query every individual record at a later date. My question is...how do I "put" this data in the other table, make sure it is there, and then delete the records from the "daily" database. Yes, I'm green. Many thanks!!