<div>
In a query, you'd need a field defined as: &nbsp;(this will return minutes, if you want hours, change &quot;n&quot; to &quot;h&quot;, days &quot;d&quot;, etc)<br />
<br />
AvgDifference: &nbsp;Avg(DateDiff(&quot;n&quot;,fldSTART,<wbr />fldUPDATED<wbr />))
</div>


In a query, you'd need a field defined as:  (this will return minutes, if you want hours, change "n" to "h", days "d", etc)

AvgDifference:  Avg(DateDiff("n",fldSTART,fldUPDATED))

<div>
Select avg(fldUPDATED - fldSTART) from YourTable<br />
<br />
How do you want to express the average? (hours, minutes, seconds)
</div>


Select avg(fldUPDATED - fldSTART) from YourTable

How do you want to express the average? (hours, minutes, seconds)

<div>
Select Format(avg(fldUPDATED - fldSTART), &quot;dd hh:nn:ss&quot;) from YourTable
</div>


Select Format(avg(fldUPDATED - fldSTART), "dd hh:nn:ss") from YourTable

<div>
SELECT Avg(DateDiff(&quot;d&quot;,[fldstart<wbr />],[fldupda<wbr />ted])) AS Expr1<br />
FROM tbl_issue;<br />

</div>


SELECT Avg(DateDiff("d",[fldstart],[fldupdated])) AS Expr1
FROM tbl_issue;


<div>
Thanks guys, exactly what I needed :) 
</div>


<div>
<div class="content wysiwyg-content">
<br />
I have a table with this structure in Access database<br />
<br />
tbl_issue<br />
&nbsp;- ID &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; (autonumber)<br />
&nbsp;- fldSTART &nbsp; &nbsp; &nbsp; (Date/Time)<br />
&nbsp;- fldUPDATED &nbsp; &nbsp; (Date/Time) <br />
<br />
<br />
Now I need to find out the average difference between the 2 dates above<br />
for all records. Question is how would I go about it ?<br />
Thanks in advance.
</div>
</div>



I have a table with this structure in Access database

tbl_issue
 - ID             (autonumber)
 - fldSTART       (Date/Time)
 - fldUPDATED     (Date/Time) 


Now I need to find out the average difference between the 2 dates above
for all records. Question is how would I go about it ?
Thanks in advance.

Generating Average time difference between 2 dates in MS Access (SQL)

Microsoft Access is a rapid application development (RAD) relational database tool. Access can be used for both desktop and web-based applications, and uses VBA (Visual Basic for Applications) as its coding language.