Calculating Average Number of Days Between Two Dates

[InstructorGirl]

My table is tblReleases
My fields are: ReleaseReceived
ReleaseCompleted
CMSEntry
JRSEntry
CRBApproval
All of these are date/time data types.

My form is frmDataSelection. I want to put these fields on a form and have the ability to select any field and enter a start date and an end date between any two dates selected on the form to calculate the average number of days. I am familiar with the DateDiff function and have used it before in a query where I am always looking at the the difference between the same dates, for example: =Avg(DateDiff("d",[ReleaseReceivd],[JRSEntry])), I just don't know where to begin with this. I will ultimately be creating a report and charting this data. Any help would be truly appreciated. Thank you!

 

[Isskint]

How are you creating an average? In general terms an average is the sum of numbers divided by the number of those numbers. In this case the number of days between 01/01/13 and 31/01/13 is 29. The sum of the days is 434. The average then is 14.97, but i suspect this is not what you are trying to calculate.


Can you manually demonstrate your average theory?

 

[InstructorGirl]

I may not have stated this correctly. I need to ask some more questions. I will re-post later. Thank you.