Aplogies for the late replies......a lot of this went to my spam folder and I have been on vacation for a week. Thanks for all the replies! Opstime is the time the flight operates. It is a time field. Dave
________________________________ From: ms_access@yahoogroups.com on behalf of phoogenb Sent: Mon 3/26/2007 5:40 PM To: ms_access@yahoogroups.com Subject: **SPAM**[ms_access] Re: Half Hour Increments??? In a query??? Eddie Van: *I* like your answer. Dave M: I guess that [Test Flt Skd] is also a query? If so, you could make a similar query that has a By Quarter Hour field instead of a By Hour field. You could do that in the way Eddie Van suggested. Otherwise, more details about your data might help in getting to a solution. What, for example, is OpsTime? Peter Hoogenboom --- In ms_access@yahoogroups.com <mailto:ms_access%40yahoogroups.com> , "Eddie Van" <[EMAIL PROTECTED]> wrote: > > 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 ms_access@yahoogroups.com <mailto:ms_access%40yahoogroups.com> > > > <ms_access%40yahoogroups.com>, Dave > > > Moreau <davem@> 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 (ms_access@yahoogroups.com > > > > <mailto:ms_access%40yahoogroups.com> <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] > [Non-text portions of this message have been removed]