By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
435,406 Members | 2,660 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 435,406 IT Pros & Developers. It's quick & easy.

Text on a report

P: 46
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,22222,33333,44444) instead of stacked?

thanks,
Jeff
Apr 20 '08 #1
Share this Question
Share on Google+
3 Replies


NeoPa
Expert Mod 15k+
P: 31,494
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?
Apr 21 '08 #2

P: 46
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
Apr 21 '08 #3

NeoPa
Expert Mod 15k+
P: 31,494
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.
Apr 21 '08 #4

Post your reply

Sign in to post your reply or Sign up for a free account.