R
Rien
I'm counting occurences of events within certain time frames. For now
i'm working with Excel (sumproduct), but I'm trying to switch to
access.
I've learned about the partition function,
SELECT DISTINCT Partition((86399*[times]),0,83699,3600) AS timeunits,
Count('times') AS verdeling
FROM tabletimes
GROUP BY Partition((86399*[times]),0,83699,3600);
This is what i'm using so far.
but it has a few drawbacks:
-it only works with integers (not very useful working with times)
-it leaves gaps where there are no events
Can these drawbacks be overcome?
i'm working with Excel (sumproduct), but I'm trying to switch to
access.
I've learned about the partition function,
SELECT DISTINCT Partition((86399*[times]),0,83699,3600) AS timeunits,
Count('times') AS verdeling
FROM tabletimes
GROUP BY Partition((86399*[times]),0,83699,3600);
This is what i'm using so far.
but it has a few drawbacks:
-it only works with integers (not very useful working with times)
-it leaves gaps where there are no events
Can these drawbacks be overcome?