Reports

[nifty001]

I have a table that houses financial statements for a given company by year and I need to display the information and add analysis information in a report format comparing year to year to year. For example:

1998 1999 2000
Income $10 $15 $22
Exspenses $8 $9 $10
Net Income $2 $6 $12

Any suggestions?

 

[Lozere]

you can achieve that with a cross tab on an Union query.

I supposed your table contains the fields Year_Fig, Expenses_Fig, Income_Fig, Net_Fig
Creat a Union Query with the following SQL string:
SELECT "Expenses" as Line_Ident, Year_Fig, Expenses_Fig as Line_Figure FROM Q_Test
UNION SELECT "Income" as Line_Ident, Year_Fig, Income_Fig as Line_Figure FROM Q_Test
UNION SELECT "Net Income" as Line_Ident, Year_Fig, Net_Fig as Line_Figure FROM Q_test;

1) Try it
2) Create a CrossTab Query based on this first query where
Line_Ident is the Line(Row?) Header, Year(Year_Fig) is the Column Header and Line_Figure the Value
You'll get the data to build your report on.

 

[nifty001]

Thanks