Sub-report?

[guldo76]

I'm running Access2k.
I have a problem: I'd need to insert, into an already existing report, the result of a query. I'd like to get it horizontal, too.
If I put it in the page header, it shows just the first record; in the main part of the report, instead, the whole result of the query is repeated for each of the already existing records (coming from a table).
Any hints to fix it????

Thanks,
Guldo

 

[jnixon]

I had this same problem about a month ago. Let me explain and see if this helps you. I pulled a query using the top 5 examples from fields already on a report (from another query). I used this top 5 query to make a subreport and wanted it to display horizontally instead of vertically. I went into Page Setup on the subreport, and found a tab called Columns. I set 5 columns on this report, and lo and behold, the subreport displayed my top 5 examples side to side (in 5 invisible columns).

Hope this helps.