I have done something similar, but not to this extent.
This is a great application for Access Basic of which I don't know very
much, so I used querys instead.
For each "group/range" of data I counted I had a separate query and
eventually I linked all the query results via a common key value = 1.
To explain this a bit better.
The first query would count OpsTime >= 7:00 and <= 07:59 and the output from
this query was in the format
Field 1 Field 2 = Qry01
Expr:=1 OpsTime
Count
Criteria >= 07:00 and <= 07:59
The next query would count OpsTime >= 8:00 and <= 08:59 and the output from
this query was in the format
Field 1 Field 2 = Qry02
Expr:=1 OpsTime
Count
Criteria >= 08:00 and <= 08:59
etc for the 24 hours.
Sorry I'm not giving you the correct syntax here. I'm just passing on the
concept.
At the end you have a Qry in which you select all these interim queries and
link them via the common Field 1 which equals 1 and this will result in one
line of data of 25 fields; ie
Flield 1 Qry01.Field2 Qry02.Field2 ......... Qry24.Field2
I am not sure, but I believe that when this runs the querys are "nested".
There may be an ACCESS limitation on the number of querys you can string
together like this. If you decide to go ahead with this method try 2 or 3
querys first and combine their results into one line of data, before you go
ahead and develop the 24 querys only to find out that they don't work.
I use ACCESS 97 and if you want more help on this, perhaps you can contact
me privately.
Ilona Wright
Adelaide, Australia
-----Original Message-----
From: ms_access@yahoogroups.com [mailto:[EMAIL PROTECTED]
Behalf Of Dave Moreau
Sent: Monday, 1 May 2006 1:52 AM
To: Access Newsgroup (E-mail)
Subject: [ms_access] Time calculations for flight operations
I have a field that is listed as "OpsTime". It is the time a flight
either arrives or departs our airport.
I am interested in grouping all times as a total Ops per hour for a graph
in Access but am having a difficult time trying to determine how to do this
in one query (if this is possible). I imagine a count function will be the
appropriate calculation.
Is this a good problem for a crosstab query to solve..... or is there
another way to sort all flight times and group them by the hour for a total
number of ops per hour? In such a manner that I can graph the results?
(all flight times are military times)
OpsTime
07:00
07:10
07:30
08:00
08:05
08:15
08:20
08:40
08:45
08:50
08:55
08:55
This group of times will provide the following results if the query works
as I hope:
0700 to 0759 = 3
0800 to 0859 = 9
I will use the numbers per hour of flight ops to produce a line graph
showing flight activity peaks and valleys throughout the day.
Thanks for any ideas!
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]
SPONSORED LINKS Microsoft access database Database development software
Database management software
Database software Inventory database software Membership database
software
----------------------------------------------------------------------------
--
YAHOO! GROUPS LINKS
a.. Visit your group "ms_access" on the web.
b.. To unsubscribe from this group, send an email to:
[EMAIL PROTECTED]
c.. Your use of Yahoo! Groups is subject to the Yahoo! Terms of
Service.
----------------------------------------------------------------------------
--
[Non-text portions of this message have been removed]
SPONSORED LINKS
| Microsoft access database | Database development software | Database management software |
| Database software | Inventory database software | Membership database software |
YAHOO! GROUPS LINKS
- Visit your group "ms_access" on the web.
- To unsubscribe from this group, send an email to:
[EMAIL PROTECTED]
- Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.
