Multiple columns on forms

[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

 

[stefan hoffmann]

hi Miguel,

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

Create a pivot query and use it as your datasource and show it as grid.

--> stefan <--