A Microsoft Office (Excel, Word) forum. OfficeFrustration

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.

Go Back   Home » OfficeFrustration forum » Microsoft Access » Setting Up & Running Reports
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

report to show 5 year trend



 
 
Thread Tools Display Modes
  #1  
Old January 7th, 2010, 11:02 PM posted to microsoft.public.access.reports
sparky
external usenet poster
 
Posts: 15
Default 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  
Old January 8th, 2010, 01:35 AM posted to microsoft.public.access.reports
KARL DEWEY
external usenet poster
 
Posts: 10,767
Default 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

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump


All times are GMT +1. The time now is 05:02 PM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 OfficeFrustration.
The comments are property of their posters.