report to show 5 year trend

  • Thread starter Thread starter sparky
  • Start date Start date
S

sparky

Access 2007.

Existing report is a excel-type spreadsheet, which I want to mimic in Access.

report has all 12 months as labels in rows A3 to A14,. column headings,
starting with A2 is "Month", B2 is "2006", C2 is "2007", and so on for 5
years, then a blank column, the the years again. Data will be KWH for first
group (B3, B4, B5, B6, B7), KW for next group of 5 years (B9, B10, B11, B12,
B13), for January, then the down one row for February, and so on. Each
column (year) will be totaled.

The purpose of this spreadsheet is side-by-side comparison of data over 5
years.

I built a table with this data as fields, but I am at a loss on how to build
a report that mimics a spreadsheet, such as described above.

How would you suggest I proceed?

The reason for using Access is that the info is generated via other reports
in this database, and instead of the office personel having to go outside of
Access to print the trend monthly, I would like for them to generate the
report from within Access.

I can email a jpg of the exisitng spreadsheet if anyones would like to
tackle this for me.

TIA

Rick Miell
 
I am at a loss on how to build a report that mimics a spreadsheet,
Search on 'Crosstab' query.
 
Back
Top