Horizontal Report

[Beady]

Hi,

I need to produce a report in which some records are repeated ACROSS the page rather than down.

If I was using Excel I'd just use Copy - Paste Special - Transpose.

Is there any way I can duplicate this approach in Access?

 

[Dennisk]

Yes, you can use a CrossTab query to transpose rows into columns.

 

[Beady]

Wow, that was quick. Many thanks.

Never used Cross tab queries, I'll take a look.

 

[Dennisk]

However,
You will have to specify what columns are required (in the XTabs property sheet otherwise the the numbers (and names) will vary ,so causing errors on your report.

 

[Rabbie]

I produced some code for a similar problem in this thread. You may find it helpful. Read the whole thread before using it because there were a few teething problems.