Run query to sum then desire to update table with values

[thatlem]

I have a DB when selected audits were initially defined for staff to enter each observation. Over time, the desire has been to change to monthly summaries. I have created new fields etc to accept the new data and new queries to pull across both data types (y/n vs. numerical).. so far so good.

However, in an attempt to clean up the database, I would like to run a query to sum the old data by month and unit, then using this query upload it back into the new fields and then delete out the old observational lines.

Is this possible? Would I need to create an intermediate table? Any advise would be good - I can't afford to lose the data. Obviously, I'd test everything first.

Thanks

 

[pcdoc32]

I suguest create a Make-table query add the fields u want in this new table and click on the icon that looks like a reversed E. this will add a total row to your query that will allow you to group by a field sum other and other option.
Once u run the query it will generate a new table with the new data if it looks like everything you need, then you go on and make changes on the original table the create a append query to bring back the data to the modified table

 

[thatlem]

thanks, will give it a try.