Went to my spam folder...will try this as well. ________________________________
From: [email protected] on behalf of Peter Groman Sent: Mon 3/19/2007 3:32 PM To: [email protected] Subject: **SPAM**RE: [ms_access] Re: Half Hour Increments??? In a query??? You could use a VBA function to give you the increment. 10th hour, 4th hour, whatever. Something like this: SELECT [Test Flt Skd].[By Hour], FindINcrement([Test Flt Skd].[FltTime]) as QuarterHr FROM [Test Flt Skd] Then create a function in the "General" code module like this: Public Function FindIncrement (dtDATE as datetime) as integer ' Determine which quarter of the hour it is, given the Time as DateTime If datepart(n,dtDATE) <= 14 then FindIncrement = 1 ' First Quarter of hour If datepart(n,dtDATE) >= 15 and If datepart(n,dtDATE) <= 29 then FindIncrement = 2 ' Second Quarter of hour If datepart(n,dtDATE) >= 30 and If datepart(n,dtDATE) <= 44 then FindIncrement = 3 ' Third Quarter of hour If datepart(n,dtDATE) >= 45 then FindIncrement = 4 ' Fourth Quarter of hour End Function This is just something quick off the top of my head - I didn't compile this or check this syntax for accuracy, so it may be off a bit, but it should be a good guide as to how this can be implemented - Pete _____ From: [email protected] <mailto:ms_access%40yahoogroups.com> [mailto:[email protected] <mailto:ms_access%40yahoogroups.com> ] On Behalf Of Dave Moreau Sent: Thursday, March 15, 2007 4:25 PM To: [email protected] <mailto:ms_access%40yahoogroups.com> Subject: RE: [ms_access] Re: Half Hour Increments??? In a query??? 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:ms_access%40yahoogroups.com> ps.com [mailto:[EMAIL PROTECTED] <mailto:ms_access%40yahoogroups.com> ps.com]On Behalf Of Dick Root Sent: Sunday, March 04, 2007 12:26 AM To: [EMAIL PROTECTED] <mailto:ms_access%40yahoogroups.com> ps.com 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] [Non-text portions of this message have been removed]
