How to set an Access report to fill in columns not in rows?

  • Thread starter Thread starter KevinD
  • Start date Start date
K

KevinD

Hello,

I'm trying to create an Access report to fill in columns and not as rows. In
this case a report with data columns is easier to read and organize. The
query feeding the report will have only a limited (5) returns/columns max so
there will be plenty of horizontal room to take the columns on the sheet.
Thanks for any help and I'm using Access 2007.
 
Without any knowledge of your tables, data, etc... I would suggest creating a
union query and then using it as the base for a crosstab query where you have
entered the Column Headings. Base your report on the crosstab query.
 
Thanks Duane. I'm not familiar with crosstab queries but I can learn. I'll
give it a go.

Kevin
 
I wouldn't put a lot of value in my answer since it was based on little or no
knowledge of your requirements or table structures. It was a guess.

If you want a little better opinion, you will need to provide a lot more
information about your needs.
 
KevinD said:
Hello,

I'm trying to create an Access report to fill in columns and not as rows.
In
this case a report with data columns is easier to read and organize. The
query feeding the report will have only a limited (5) returns/columns max
so
there will be plenty of horizontal room to take the columns on the sheet.
Thanks for any help and I'm using Access 2007.
Click to expand...

Perhaps I'm misunderstaning, but it appears to me that you simply want to
display your records in columns... in design view of the Report, on the
menu, File | Page Setup, and then click on the Columns tab of the dialog,
set the columns, display the report, adjust until you get it looking the way
you want.

Larry Linson
Microsoft Office Access MVP
 
Back
Top