Averages

  • Thread starter Thread starter Jeff
  • Start date Start date
J

Jeff

How in the world can I get the average for several blocks
of data in the row. Not for the column. I need to show
the average flight hours for our aircraft over the last 6
and 12 months. This is driving me crazy. I've looked up
every concevable reference online for averages but it
keeps tripping me up. Any help would be appreciated.

Jeff
 
Don't you think you should share
-your table structure
-sample data records
-desired results
 
Hey Duane,

Well, each month we log the flight hours for each of
our aircraft to see if is has gone over its restricted
flight hours. I need to average out the last six months
and the last 12 months of data to see if they are reaching
their monthly limit.

A/C# Jan Feb Mar Apr etc... 6mthavg 12mthavg
#### 9.0 27 40 35 etc... 55 29

Its pretty straight forward. Just average the montly
flight hours. I hope this helps you picture what I'm
trying to do. Thanks for your help.

Jeff
 
I assume you start with the current month (this month, or last month) and
your heading in your report will reflect it. Like if we were doing it today
your heading would be feb 04-jan 05 with flight hours underneath. if so next
month the heading would be mar 04-feb 05. then under 6 month avg it would be
then name of field in the report (they should not change they should
probably be mon1- mon12) of the last 6 months (mon7- mon12) added together
divided by 6 and then you'd do the same for 12 months. This would be done on
the report field not in the query. In the query you need to use aliases
(mon1:[field]) to match your report. This isn't simple to do and doubt i
explained it well enough. It took me a while the 1st time to figure it all
out.

HTH
Martin J
 
Do you actually have fields named Jan, Feb,...? If so, consider normalizing
your table structure before you do anything else.
 
Back
Top