How do I change this query to a half an hour or even a 15 minute increment
rather than 1 hour.
By Hour: Hour([MEMTime])
Group by
It is taking the MEMTime field (a time field only) and grouping the number of
flights during each hour.
I get:
06:00 58
07:00 81
08:00 29
09:00 10
etc.....
What I would like is:
06:00 06:29 50
06:30 06:59 8
07:00 07:29 40
07:30 07:59 41
and so on.....I just want to break it out by half hour for now instead of by
each hour. The table just has flight departure times.
Thanks!
Dave
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]
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/
