Datasheet layout on report?

[Alan]

Hello,

Currently my report lays data out like the following:

Market
Oil & Gas
Awarded $5,000
Budgetary $1,000
Lost $2,000
Pending $10,000
Construction
Awarded $10,000
Budgetary $300
Lost $5,770
Pending $5,678

But I'd like to have it lay it out like the following:

Market Awarded Budgetary Lost Pending
Oil & Gas $5,000 $1,000 $2,000 $10,000
Construction $10,000 $300 $5,770 $5,678

Is there a way to do this?

Thanks,

Alan

 

[Duane Hookom]

I expect you could create a crosstab query to use as the record source of
your report. This depends on your table structure which we really don't
understand.

 

[Evi]

Hello,

Currently my report lays data out like the following:

Market
Oil & Gas
Awarded $5,000
Budgetary $1,000
Lost $2,000
Pending $10,000
Construction
Awarded $10,000
Budgetary $300
Lost $5,770
Pending $5,678

But I'd like to have it lay it out like the following:

Market Awarded Budgetary Lost Pending
Oil & Gas $5,000 $1,000 $2,000 $10,000
Construction $10,000 $300 $5,770 $5,678

Is there a way to do this?

Thanks,

Alan

It looks like you may have created a Columnar report when you really wanted
a Tabular one.
Have you tried sliding your fields around in Report Design view?

Evi