I got help earlier and have been pointed in the direction of a Crosstab, but have been unsuccesful in getting the information to convert in the Crosstab query. I created a table that reproduces the old table's column headings into row headings, but the row headings have no referential integrity (problem) and the end result isn't worth anything.
The goal is to make the existing table into a financial statement(s) report with a Crosstab query?
I have a table that houses the following Field Names:
Design View:
1) FinclsID
2) FinclsDetailID
3) AuditStatusID
4) FinancialStmtsDate
5) OtherIncome
6) OtherExp
7) TotalDebt
8) TotalAssets
9) RetainedEarnings
Datasheet View (omitting column headings):
56,2,1,12/31/98,$10,$8,$50,$100,$50
56,3,1,12/31/99,$9,$7,$50,$99,$49
56,4,1,12/31/00,$5,$4,$23,$50,$27
I need to change the current column headings from 1,2,3,5,6,7,8,9 and change them to "3,4" and make the row headings 5,6,7,8,9 with grouping by 1,2. The information displayed on the report needs to grow as new financial statements are added.
The goal is to make the existing table into a financial statement(s) report with a Crosstab query?
I have a table that houses the following Field Names:
Design View:
1) FinclsID
2) FinclsDetailID
3) AuditStatusID
4) FinancialStmtsDate
5) OtherIncome
6) OtherExp
7) TotalDebt
8) TotalAssets
9) RetainedEarnings
Datasheet View (omitting column headings):
56,2,1,12/31/98,$10,$8,$50,$100,$50
56,3,1,12/31/99,$9,$7,$50,$99,$49
56,4,1,12/31/00,$5,$4,$23,$50,$27
I need to change the current column headings from 1,2,3,5,6,7,8,9 and change them to "3,4" and make the row headings 5,6,7,8,9 with grouping by 1,2. The information displayed on the report needs to grow as new financial statements are added.
