Calculating Days between Dates from a Specific Record

[WillJ]

Hi Guys,

I have a query that records a status update, and the date it was made by an employee etc. The table has a secondary key related to ... lets say a project table.
E.g.
Status Id; EmployeeID;ProjectsID;Status;Date

I want to calculate the average amount of days it takes for a status change occur. :banghead:

This is confusing me a tad ... there is a bridge in my head I have not built yet.

Any advice, pointers or general critique is mucho gracie!

 

[AlexHedley]

This may point you in the right direction.


Using DateDiff and DateAdd to Determine Differences in Dates

http://www.599cd.com/tips/access/dates-datediff-dateadd/


You could work out the difference then use an Aggregate function to work out the Average.