Date Intervals from dates

[c8tz]

Hi,

I've created a query that lists the dates between a start date and an
end date. From the list of dates, i need to find the intervals
between the dates and then find the average of that.
How do I get the intervals in a column in the query.

thanks heaps

 

[Allen Browne]

See:
Subquery basics: Get the value in another record
at:
http://allenbrowne.com/subquery-01.html#AnotherRecord

The example is for the previous meter reading so you can subtract from the
current value, but it works the same for dates.

 

[c8tz]

See:
Subquery basics: Get the value in another record
at:
http://allenbrowne.com/subquery-01.html#AnotherRecord

The example is for the previous meter reading so you can subtract from the
current value, but it works the same for dates.

--
Allen Browne - Microsoft MVP. Perth, Western Australia
Tips for Access users -http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.








- Show quoted text -

thanks allen.