Company financials report

[richary]

I'm sure there must be an easy way to do this..

I would like a report to list company financial information for the past few quarters (haven't decided yet, probably 4 or 5).

I would like the structure below

                          June 05             Mar 05         Dec 04
Net Income             $xx                     $xx           $xx
Cost of Revenue      $yy                      $yy          $yy
.
.
.

Each line is a field in a table (tblIncome).

However, I'm having trouble laying out the table. Columns seem to be the obvious solution, but that means the lables (Net income etc.) are printed out on each column. I could have a normal report and use Dlookup for each field, for each quarterly result but that would take a long time (I think) and is not very elegant.

Is there another way?

 

[Sammy B]

Look at the 'Quarterly Orders by Product' in the North Wind sample. This is the elegant way to do this. Base your report on a query built along the same lines.

Sam

 

[richary]

Thanks for the quick reply, Sam.

I'm not sure I can use the idea, elegant as it is. I have my table organised with fieldnames NetIncome, CostOfRevenue, ResearchDevelopment plus about 12 more, so I think I break the limits for a crosstab query.

 

[Sammy B]

I believe you can have as many rows you need grouped as 'row headings'. There is no limit as far as I know.

 

[richary]

Got it to work. Thanks for your help!