D
DavisGail
Is it possible to run a query with a time column and get the averages for
each 15 minute time increment?
each 15 minute time increment?
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
B
BruceM
Since nobody has answered I suspect others are as puzzled as I about what
you are asking.
you are asking.
M
Michael Gramelspacher
Is it possible to run a query with a time column and get the averages for
each 15 minute time increment?
Maybe you are looking for something like this example:
SELECT DATEADD("n", (DATEDIFF("n", 0, [DataRates].Time_Stamp)\15)*15, 0) AS [Time Block],
Avg([DataRates].Throughput) AS [Avg Rate]
FROM DataRates
GROUP BY DATEDIFF("n", 0, [DataRates].Time_Stamp)\15)*15
Useing the table DataRates it groups the Time_Stamp column in 15-minute intervals and averages the
Throughput column.
Not tested.
J
John Spencer (MVP)
Wild guess
SELECT Minute(YourField)\15 +1 as Interval
,Avg(SomeField) as TheAverage
FROM SomeTable
GROUP BY Minute(YourField)\15 +1
That will group in 4 groups
1 - 00 to 14
2 - 15 to 29
3 - 30 to 44
4 - 45 to 59
If you want 1 to 15, 16 to 30, etc you will need to make a modification to the
expression you are using to calculate interval.
And yes, the \ is correct since I am using integer math to calculate the interval.
John Spencer
Access MVP 2002-2005, 2007-2009
The Hilltop Institute
University of Maryland Baltimore County
SELECT Minute(YourField)\15 +1 as Interval
,Avg(SomeField) as TheAverage
FROM SomeTable
GROUP BY Minute(YourField)\15 +1
That will group in 4 groups
1 - 00 to 14
2 - 15 to 29
3 - 30 to 44
4 - 45 to 59
If you want 1 to 15, 16 to 30, etc you will need to make a modification to the
expression you are using to calculate interval.
And yes, the \ is correct since I am using integer math to calculate the interval.
John Spencer
Access MVP 2002-2005, 2007-2009
The Hilltop Institute
University of Maryland Baltimore County