PC Review


Reply
Thread Tools Rate Thread

Display multiple records from same ControlSource

 
 
SummitSeeker
Guest
Posts: n/a
 
      2nd Jun 2010
I am trying to display multiple records in one text box on a report. I can
get it to work if I put the text box in the "Details" section of the report,
but I need it to be displayed at the bottom of the report.

Is there a way to move the "Details" Section to the bottom of the report?

Is there a way to get more than one resord to be displayed in one text box?

Thanks like always for the help...
-H-


 
Reply With Quote
 
 
 
 
Wolfgang Kais
Guest
Posts: n/a
 
      3rd Jun 2010
Hello "H".

"SummitSeeker" wrote:
> I am trying to display multiple records in one text box on a report.
> I can get it to work if I put the text box in the "Details" section
> of the report, but I need it to be displayed at the bottom of the
> report.
>
> Is there a way to move the "Details" Section to the bottom of the
> report?

No.

> Is there a way to get more than one resord to be displayed in one
> text box?


No.

> Thanks like always for the help...


The report header/footer or a form header/footer is a section that is
only not repeated, but in general all other sections like page header
or footer, group header or footer and also the details section is
ment to be repeated several times. Especially the details section is
repeated for every record of the record source of the form or report.
Therefore, if you see multiple textboxes displaying data from multiple
records, it's not one textbox that contains multiple records, instead
there are multiple copies of the details section, one for each record.
(In VB6, to achieve the same result, one had to create a custom
control for that section that was repeated in a DataRepeater control.)
The is a predefined order or hirarchy of sections in a report that can
not be changed. From what you describe, it seems to me that you want
to display a list of certain items in the report footer. To achieve
this, you may have to create a report that only displays your list
(maybe containing only a details section that repeats a textbox) and
place it as a subreport in the report footer of your report.

--
Regards,
Wolfgang


 
Reply With Quote
Reply

Thread Tools
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
Multiple records in table to display single records Hurrikane4 Microsoft Access Queries 7 10th Dec 2009 06:34 PM
Display multiple query records in one row =?Utf-8?B?Q2FybA==?= Microsoft Access 1 29th Mar 2007 11:10 PM
How to display multiple records on a form. §Chrissi§ Microsoft Access 2 10th Jan 2006 09:27 PM
Multiple Records but only display most current Adrian Mundy Microsoft Access Reports 1 17th May 2005 06:36 PM
Need Help - display multiple records Billie Microsoft Access Form Coding 2 11th Oct 2004 04:16 PM


Features
 

Advertising
 

Newsgroups
 


All times are GMT +1. The time now is 05:40 PM.