Using a query to update existing records.

drogerson

New member
Local time
Today, 14:58
Joined
Oct 17, 2011
Messages
6
Basically, I have a table of data with plenty of records (10,000+)

They all have 4 fields in common which must have data entered. The unique data is TIME.

I have already done a group sort query which has identified the group's of data based on these 4 fields, and then calculated an average time for each group.

I'm now needing to re-insert the average time against the real time in a table so each individual record's time can be evaluated against the average of its type.

Is this even possible?

Thanks in advance.
 
When viewing the query builder there is an icon on the toolbar at the top of the Access window which is a red exclamation mark (the colour may differ in other versions of Access) which allows you to change it from a select query to an action query.

In this case you want an update query. This adds an "Update To" row to the query, any field with something entered in there will be updated to what you input. Criteria still apply to let you update only certain records and datasheet view can still be sued to check which records are returning.
 

Users who are viewing this thread

Back
Top Bottom