Normalizing column names

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

OK, let's take a different tact with this problem. I have to make a report
to show the following:

Aircraft Number Jan Feb Mar Apr May etc... 6 mth avg 12 mth avg
162316 9.7 92.5 45.4 60.1 75.5 etc ##.##
##.##
159318 7.9 0.0 etc... ##.##
##.##
160769 58.5 24.7 32.4 13.6 etc... ##.##
##.##

Each month I have to plug in the number of flight hours that plane flew
(i.e. Jan, Feb, Mar, etc) then I have to show the average number of flight
hours for the previous six and 12 months. How do I label the month columns
in order to make up an expression to average out the previous six months from
the current month? Also, what would the expression be to collect all the
data I need (I figure it would have to be written as a Sum equation that adds
the previous six months and divides by 6) in order to show the information in
the report.

The year plays no part in these figures. It is just the number of flight
hours for January. The data will be replaced each new calendar year.

Any help would be appreciated.

Thanks,

Jeff
 
What is your table structure? I hope is doesn't have fields with names like
Jan, Feb,...
 
Duane,

That's the problem I'm trying to figure out. Originally it was going
to be that but the more I research this and other sites I know that will not
work and I am at a loss in how to normalize the field names. I know it will
affect the way the data can be called up into the formula but I am stumped.
Any help would be appreciated.

Thanks,

Jeff
 
I wouldn't spend any more time on the application prior to normalizing. I
would expect a table with fields like:
AircraftNumber
FlightDate
FlightHours
 
Back
Top