Calculating the earliest date using an update query

[Rod]

Hi,

I am completely new to access and am getting really stuck.

I have two tables as below:

Projects
Project Name
Description
Owner
Start Date
End Date

Tasks
Task Name
Project Name
Assigned Resource
Start Date
End

Each project will have a number of tasks assigned to it that must be completed before the project is set to complete. Therefore the overll dates of my project are based on the dates of the tasks. I want to write a query that would allow me to update the overall start and end date on my project table with the earliest start date and latest end date of all the tasks assigned to that project.

I hope that makes sense. I have tried using the DMin and DMax functions but am not sure i am getting them right or if they are even the right way to go.

Any help would be very much appreciated

 

[namliam]

This start and end date is a aggregated value of other values inside your database, you shouldnt store this as a value, because if one of the dates changes, then this date (could) change as well. And you keep going round and round.

Instead 'simply' calculate on the fly.

 

[Rod]

Thanks for your help Namliam