Update query

[Brad]

Thanks for taking the time to read my question.

I need to run an update query, but only on the MAX dates of the records.
When I try to run the update query it says it can only be run on an
updateable query. I'm guessing because I have the Group on, it can't be done.
With the Max date in place I have 129 records to update, if not I'm going to
update over 1000 records.

I tried saving the query as a select query instead, then joining it in a new
query to the table that holds the data to filter it that way, but I get the
same result.

Any way I can do this? Otherwise it's going to take quite some time to do it
manually.

Brad

 

[KARL DEWEY]

I tried saving the query as a select query instead, then joining it in a new
query to the table that holds the data to filter it that way, but I get the
same result.

Post the SQL on both queries.

 

[Brad]

Thanks for the reply Karl,

I wrote some VBA instead, it was a rush job. I created 2 recordsets, and
worked with it like that.

Brad