Text on a report

[jmar93]

Hi,

I'm using Access 2007. I need help getting record to display correctly on a report. The report gets it data from a query that find all PO#'s for a given customer and then displays them in a text box on the report. The problem is that the results are stacked on the report one under the last and if there are enough PO#'s the text box will expand to the point that it pushes other fields to a 2nd page and that is not acceptable. Is there a way to get the PO# results to display as such,(11111,222 22,33333,44444) instead of stacked?

thanks,
Jeff

[NeoPa]

I can't see, from your explanation, why a TextBox on your report would expand or contain a list of the items.

Surely, as you've described, the records would appear separately down one page then onto the next?

[jmar93]

I can't see, from your explanation, why a TextBox on your report would expand or contain a list of the items.

Surely, as you've described, the records would appear separately down one page then onto the next?

Yes, that is exactly what they are doing. I should have stated that the detail section of my report expands and pushes other parts of the report to a second page. The report is a bill of lading and needs to be only one page, so I need a way to make the records display horizontally instead of stacked.

thanks,
Jeff

[NeoPa]

So you really need a query that returns a single item from all the matching records you want to include on your bill of lading?

If that is the case then Access doesn't do this for you naturally.

Check out Combining Multiple Rows of one Field into One Result & Combining Rows-Opposite of Union.

PS. I also found Producing a List from Multiple Records.