Oh...and here is the crosstab query that the sql select below runs off of. In
stead of by hour I'd like by half an hour and every 15 minutes. So if a flight
departs at 7:01am then it will show for selected times between 0700 and
0715.......or 0700 and 0730, instead of between the entire hour 0700 and 0800.
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;
-----Original Message-----
From: [email protected] on behalf of Dave Moreau
Sent: Thu 10/5/2006 6:18 PM
To: [email protected]
Cc:
Subject: [ms_access] Change from hour query
How do I change from hour increments to half hour or every 15 minutes
in this query...this query drives a graph that presents flight arrival and
departure totals by hour. I'd like to break it down to half an hour or every 15
minutes.
SELECT [By Hour],[FED],[NWA] FROM [qryCombinedFltAksArrDep];
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.
Yahoo! Groups Links
<*> To visit your group on the web, go to:
http://groups.yahoo.com/group/ms_access/
<*> Your email settings:
Individual Email | Traditional
<*> To change settings online go to:
http://groups.yahoo.com/group/ms_access/join
(Yahoo! ID required)
<*> To change settings via email:
mailto:[EMAIL PROTECTED]
mailto:[EMAIL PROTECTED]
<*> To unsubscribe from this group, send an email to:
[EMAIL PROTECTED]
<*> Your use of Yahoo! Groups is subject to:
http://docs.yahoo.com/info/terms/
