Date Criteria in Update Query

[mech55]

What I want to do is from several records find the Max() date and update that one record with my stuff. However, I get an error message cannot use aggregate in update query or something to do that effect. Is there a way to get around this?

 

[Vassago]

You could do one query to find the max date, then do another separate update query which links the date field to your first query.