Can anyone help with this...or is it already so messed up that it is not making any sense? Thanks! Dave -----Original Message----- From: [email protected] [mailto:[EMAIL PROTECTED] Behalf Of Dave Moreau Sent: Wednesday, January 24, 2007 10:32 AM To: Access Groups (E-mail) Subject: [ms_access] FW: Half Hour Increments??? In a query???
_____ From: Dave Moreau [mailto: [EMAIL PROTECTED] <mailto:dmoreau%40midsouth.rr.com> rr.com] 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]
