Re: Grouping Into 1/2 Hour Time Buckets

raskew wrote:
Hi -
Take a look at this post
http://www.accessmonster.com/Uwe/Forum.aspx/access-queries/16462/Partition-Time
. The third posting uses the partition() function and breaks it down into 15
minute intervals. Divide by 450 instead 900 for 1/2 hour periods.

Bob

Good afternoon.
I would like to collect the following information (via a form).
[quoted text clipped - 13 lines]

Thanks


Thanks for the help Bob.
If I give an example, maybe you can help me further. Data in table would be
like:

Process Start End
1234ABCD 1/1/2008 12:20 AM 1/2/2008 10:30
PM
WXYZ9999 1/1/2008 1:30 AM 1/3/2008 11:30
AM

There can be multiple processes running at the same time.

Query to provide this:

Time Interval
Process
1/1/2008 12:00 AM - 1/12008 12:29 AM 1234ABCD
1/1/2008 12:30 AM - 1/12008 12:59 AM 1234ABCD
1/1/2008 1:00 AM - 1/1/2008 1:29 AM 1234ABCD
1/1/2008 1:30 AM - 1/1/2008 1:59 AM 1234ABCD
1/1/2008 1:30AM - 1/1/2008 1:59 AM WXYZ999

and so on..............................

At that point, I could group and count based on the Time Interval.

Is this possible??

.

Relevant Pages

  • Re: List partitioning
    ... topmost reduction of a search for an optimal partition of N items into P groups where P does /not/ divide N, into searches over all ways of distributing the N items into complementary subsets of N' and N'' items, to divide in turn into P' and P'' groups respectively. ... For each choice of distribution of N items into N'- and N''-sized subsets, the further optimal partition of each of these complementary subsets can then proceed independently. ...
    (comp.lang.prolog)
  • Re: Philosphy of programming
    ... > advance (I'll partition my reality in such a way that the ... > different parts will only interact in predefined ways, ... Then divide those and so on. ...
    (comp.programming)
  • Re: nee help please reinstalling xp with new partitions
    ... not sure why it would boot into the CD set up while it was in the ... maybe it will make things easier to divide it up a bit... ... I'd say to set the C: drive for at least 40 gigs or so ... There is no way to expand a partition in XP? ...
    (microsoft.public.windowsxp.help_and_support)
  • Re: List partitioning
    ... topmost reduction of a search for an optimal partition of N items into P groups where P does /not/ divide N, into searches over all ways of distributing the N items into complementary subsets of N' and N'' items, to divide in turn into P' and P'' groups respectively. ... For each choice of distribution of N items into N'- and N''-sized subsets, the further optimal partition of each of these complementary subsets can then proceed independently. ...
    (comp.lang.prolog)