473,324 Members | 1,646 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,324 software developers and data experts.

Text on a report

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
3 1366
NeoPa
32,556 Expert Mod 16PB
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
jmar93
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
32,556 Expert Mod 16PB
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

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

Similar topics

3
by: deko | last post by:
I store hyperlinks as text in a table like this: Invoice11-21-2003.pdf#file://P:\Finance\PrefVendors\Receipts\Invoice11-21-20 03.pdf I need to run a report that lists the documents - or...
5
by: Cro | last post by:
Hello Access Developers, I'd like to know if it is possible to perform a count in an expression that defines a control source. My report is based on a query. In my report, I want a text box to...
3
by: Not Me | last post by:
Hi, I have a report, viewable in continuous form. I don't want the size of the report to change (it should fit address labels on the printer), but in order to minimise the space between empty...
3
by: akparasite | last post by:
Hello all, I have a text box in the page header of my Access report that takes a dynamic string value from a named text box on an open form as its control source, written as follows: ...
2
by: john | last post by:
My report is based on a query with user input . In my report I have a text box with the following code: =. This works when the query outcome is 1 or more records. But when the query output is zero...
13
by: penjddj1 | last post by:
(Please forgive any misuse of terms in my description as this is my first post.) I have created a text box (in a report) that is used to find a percentage based on two other controls. The...
4
by: Andrew Meador - ASCPA, MCSE, MCP+I, Network+, A+ | last post by:
I have created a report. This report needs to display records between two dates entered by the user. I put two text boxes on the report so I can enter the start and end date - I set them to use an...
2
by: thomasprabu | last post by:
Please help me regarding this problem I use jasper report for report in my web project (Tomcat). I use to save the report in .rtf file and from java I read the text and i display in the browser....
5
by: dm3281 | last post by:
Hello, I have a text report from a mainframe that I need to parse. The report has about a 2580 byte header that contains binary information (garbage for the most part); although there are a...
5
by: Sep410 | last post by:
Hi all, I have a report in access. in detail section of the report I have a text box which holds the price for each inventory. There are some calculations in the control source of the text box. I...
0
by: DolphinDB | last post by:
Tired of spending countless mintues downsampling your data? Look no further! In this article, you’ll learn how to efficiently downsample 6.48 billion high-frequency records to 61 million...
0
by: ryjfgjl | last post by:
ExcelToDatabase: batch import excel into database automatically...
1
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
0
by: Vimpel783 | last post by:
Hello! Guys, I found this code on the Internet, but I need to modify it a little. It works well, the problem is this: Data is sent from only one cell, in this case B5, but it is necessary that data...
1
by: CloudSolutions | last post by:
Introduction: For many beginners and individual users, requiring a credit card and email registration may pose a barrier when starting to use cloud servers. However, some cloud server providers now...
1
by: Defcon1945 | last post by:
I'm trying to learn Python using Pycharm but import shutil doesn't work
1
by: Shællîpôpï 09 | last post by:
If u are using a keypad phone, how do u turn on JavaScript, to access features like WhatsApp, Facebook, Instagram....
0
by: af34tf | last post by:
Hi Guys, I have a domain whose name is BytesLimited.com, and I want to sell it. Does anyone know about platforms that allow me to list my domain in auction for free. Thank you
0
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 3 Apr 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome former...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.