Dave,
Maybe you could do a group-by/order-by (hour/4)
Dick
--- In [email protected], 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])
> 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]
>
