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:[EMAIL PROTECTED] On Behalf
Of Dave Moreau
Sent: Thursday, March 15, 2007 4:25 PM
To: [email protected]
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]
