Aggregate function + update query problem

[sglavanovi]

Hi, everyone!
I have 2 tables in my access database and I'm trying to update a field in one table with the minimum value (date) of the field in another table. I have created query to find minimum value in table 1 but I'm not sure how to update value in table 2. Tables are linked via ID filed.
Any help is appreciated.

 

[Trevor G]

Create an additional query on the source you have in your query that finds the minimum value then change the query type to an update. You can always check out YouTube for samples of Update Queries in Access.

 

[RainLover]

What you are trying to do is to store a calculated value. This is not a good practice.

Instead you should find the value when you need to use it. "At Runtime"

Please read up on Storing Calculated Values. Google is a good place to start.

 

[sglavanovi]

I've managed to solve my problem by combining dlookup function with my select and update queries.
Thx anyway!