I was wondering ...... Was my answer that stupid that it even doesn't merit a short reply ?
On 3/4/07, Eddie Van <[EMAIL PROTECTED]> wrote: > > Dave, > Something like adding a field to your query, rounding the date to quarters > of an hour maybe ? > RoundedDate: Format(Int(([YourDate])*24*60/15)/24/(60/15);"yyyy/mm/dd > hh:nn") > Group by this field (not by your original date). > > On 03 Mar 2007 22:28:48 -0800, Dick Root <[EMAIL PROTECTED]> wrote: > > > > Dave, > > Maybe you could do a group-by/order-by (hour/4) > > Dick > > > > --- In [email protected] <ms_access%40yahoogroups.com>, Dave > > Moreau <[EMAIL PROTECTED]> wrote: > > > > > > Never heard back from anyone on this one? Any ideas out there? > > This works for hourly reports...just want to break it down further. > > > > > > -----Original Message----- > > > From: Dave Moreau > > > Sent: Wednesday, January 24, 2007 10:32 AM > > > To: Access Groups (E-mail) > > > Subject: FW: Half Hour Increments??? In a query??? > > > > > > > > > > > > _____ > > > > > > From: Dave Moreau [mailto:[EMAIL PROTECTED] > > > > > Sent: Saturday, January 20, 2007 9:48 PM > > > To: Access ([email protected] <ms_access%40yahoogroups.com>) > > > Subject: Half Hour Increments??? In a query??? > > > > > > > > > How can I get this chart to reflect operations by half hour or every > > 15 minutes? > > > I have tried a number of different ways to do this but have not had > > any success. > > > Right now, the chart shows how many flights depart and arrive during > > each hour time slot during 24 hours. I need to break it down further > > to half hour or 15 minute increments. Cane someone out there in brain > > trust land help out a rookie? > > > > > > > > > Chart for hourly flight ops > > > SELECT [By Hour],[FED],[NW],[9E],[XJ] FROM [qryCombinedFltAksArrDep]; > > > > > > Query Select statement uses. > > > > > > TRANSFORM Max([Test Flt Skd].OpsTime) AS MaxOfOpsTime > > > SELECT [Test Flt Skd].[By Hour] > > > FROM [Test Flt Skd] > > > GROUP BY [Test Flt Skd].[By Hour] > > > PIVOT [Test Flt Skd].Airline; > > > > > > > > > > > > This e-mail and any attachments may be confidential or legally > > privileged. If you receive this message in error or are not the > > intended recipient, you should destroy the e-mail message and any > > attachments or copies, and you are prohibited from retaining, > > distributing, disclosing or using any information contained herein. > > Please inform us of the erroneous delivery by return e-mail. Thank > > you for your cooperation. > > > > > > > > > > > > > > > [Non-text portions of this message have been removed] > > > > > > > > > > > > > -- > Eddie -- Eddie [Non-text portions of this message have been removed]
