M
Miguel Velez
I got a table something like:
Month Revenue Cost Profit
----- ------- ------ ------
1/5/04 $10,000 $7,000 $3,000
1/6/04 $12,000 $7,850 $4,150
1/7/04 $6,000 $8,000 -$2,000
But I want to display it on the for like:
May-04 Jun-04 Jul-04
Revenue $10,000 $12,000 $6,000
Cost $7,000 $7,850 $8,000
Profit $3,000 $4,150 -$2,000
Ass new months are added to the table, they would appear
on the form as additional columns. In essense, it's a
continuous form but going across the form, not down.
Does anyone have any ideas/tricks as to how I could do
this?
Any help will be most welcome.
Michael
Month Revenue Cost Profit
----- ------- ------ ------
1/5/04 $10,000 $7,000 $3,000
1/6/04 $12,000 $7,850 $4,150
1/7/04 $6,000 $8,000 -$2,000
But I want to display it on the for like:
May-04 Jun-04 Jul-04
Revenue $10,000 $12,000 $6,000
Cost $7,000 $7,850 $8,000
Profit $3,000 $4,150 -$2,000
Ass new months are added to the table, they would appear
on the form as additional columns. In essense, it's a
continuous form but going across the form, not down.
Does anyone have any ideas/tricks as to how I could do
this?
Any help will be most welcome.
Michael