If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
report to show 5 year trend
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 |
#2
|
|||
|
|||
report to show 5 year trend
I am at a loss on how to build a report that mimics a spreadsheet,
Search on 'Crosstab' query. -- Build a little, test a little. "sparky" wrote: 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 |
Thread Tools | |
Display Modes | |
|
|