My database is based on the status of applications.
I have a basic tracking table called LogT which is updated when a record in CaseT (application) is changed.
LogT - LogID, Application, Stage, DateUpdated
Each time an application in CaseT changes stage, it is logged in a table called LogT and the date of change is recorded next to it.
I want to create a query that will look at the log table, check each Application which will have more than one record and calculate the number of days between each stage it has passed through.  Maybe send the result to an Excel table.
I know what I want it to do but can’t think for the life of me how to do it.  Please advise.