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 [Non-text portions of this message have been removed]
