G
Guest
I have been working on this for two days straight. I am fairly certain I
solved this problem a year ago myself but can't remember how.
I have a form and subform. The Form is based on a TableCompany with a Field
called Company that is the primary key. The subform is based on TableIncome
with fields Company, Year, Revenue, and Expenses. For each Company in the
Form, the subform correctly shows multiple records for the Year, Revenue, and
Income for the Company selected with the field names at the top and rows
beneath, as follows.
Year Revenue Expense
2001 $100 50
2002 $200 60
2003 $300 70
However, I need to put the field names on the left with multiple columns to
the right as follows so that it reads like a typical Financial Income
Statement
Year 2001 2002 2003
Reveue $100 $200 $300
Expense 50 60 70
I have looked at the property sheet for forms, subforms, detail, etc. I
have played with Default View for Single Form, Continuous Form, and
Datasheet. No success.
Would very much appreciate your help. (Please note that in reality I am
dealing with Income Statements, Balance Sheets, and Cash Flow statements with
over 300 fields for over 200,000 records that will benefit from this
solution. I gave a simplified example of my problem.)
solved this problem a year ago myself but can't remember how.
I have a form and subform. The Form is based on a TableCompany with a Field
called Company that is the primary key. The subform is based on TableIncome
with fields Company, Year, Revenue, and Expenses. For each Company in the
Form, the subform correctly shows multiple records for the Year, Revenue, and
Income for the Company selected with the field names at the top and rows
beneath, as follows.
Year Revenue Expense
2001 $100 50
2002 $200 60
2003 $300 70
However, I need to put the field names on the left with multiple columns to
the right as follows so that it reads like a typical Financial Income
Statement
Year 2001 2002 2003
Reveue $100 $200 $300
Expense 50 60 70
I have looked at the property sheet for forms, subforms, detail, etc. I
have played with Default View for Single Form, Continuous Form, and
Datasheet. No success.
Would very much appreciate your help. (Please note that in reality I am
dealing with Income Statements, Balance Sheets, and Cash Flow statements with
over 300 fields for over 200,000 records that will benefit from this
solution. I gave a simplified example of my problem.)