Will give that a shot as well....seems I can't get it resolved yet but I'll bet it is not suggestions such as yours as much as it is my new coding, or lack thereof, skills. I appreciate the efforts. Will let you know when I finally get something to work. My sincere thanks for the replies. Dave
-----Original Message----- From: [email protected] [mailto:[EMAIL PROTECTED] Behalf Of Dick Root Sent: Sunday, March 04, 2007 12:26 AM To: [email protected] Subject: **SPAM**[ms_access] Re: Half Hour Increments??? In a query??? Dave, Maybe you could do a group-by/order-by (hour/4) Dick --- In [EMAIL PROTECTED] <mailto:ms_access%40yahoogroups.com> ps.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] <mailto:ms_access%40yahoogroups.com> ps.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] > [Non-text portions of this message have been removed]
