average time between two date ranges

[Guest]

Need to find out the average number of days between the date and the ship
date. This needs to be shown line by line for a future report. I am new to
access so not that familiar with writing code to do this.

date SHIPDATE
01-Jul-06 11-Jul-06
01-Jul-06 03-Jul-06
03-Jul-06 06-Jul-06
03-Jul-06 13-Jul-06
03-Jul-06 13-Jul-06

TIA,
Marilyn

 

[Duane Hookom]

You can use SQL like:

SELECT Avg(DateDiff("d",[Date], [SHIPDATE]) As AvgDays
FROM tblNoNameGiven;

Or you can set a control source to something like:
=DAvg("DateDiff('d',[Date], [SHIPDATE])","tblNoNameGiven")

 

[Guest]

Thank you! it worked for me.

You can use SQL like:

SELECT Avg(DateDiff("d",[Date], [SHIPDATE]) As AvgDays
FROM tblNoNameGiven;

Or you can set a control source to something like:
=DAvg("DateDiff('d',[Date], [SHIPDATE])","tblNoNameGiven")


--
Duane Hookom
MS Access MVP

Need to find out the average number of days between the date and the ship
date. This needs to be shown line by line for a future report. I am new to
access so not that familiar with writing code to do this.

date SHIPDATE
01-Jul-06 11-Jul-06
01-Jul-06 03-Jul-06
03-Jul-06 06-Jul-06
03-Jul-06 13-Jul-06
03-Jul-06 13-Jul-06

TIA,
Marilyn