apend memo field from muliple records within one detail

[David Smith]

Trying to create a report that consolidates multiple records on a
pre-printed form. How do I append the same memo field from multiple records
so that it prints in the same detail pass?

David

 

[Rick B]

You can't. A detail record (section) is for one record. How would you tell
it which records to combine?

You could add a subreport that contains all the memo fields you want and
place that on the report so it shows them under the single records detail
information.

There are lots of ways to go about making this appear to be listed under the
primary data for one record. You'd need to give us a lot more detail to get
a better response.

Rick B

 

[David Smith]

I was hoping a query would allow the same field from multiple records to be
combined into a single field prior to printing. I have created a query to
select from the database records that need be printed. The preprinted form
onto which the results would print is a ncr multi-page document used by
several departments. It is an incident summery report which is not generated
until a minimum number of incidents are recorded, then all incidents are
summarized on the single report. That report is sent by messenger to remote
departments. Computer access is not universally available so hard copy must
be used. After each department's input the database is updated by their
notation. Multiple passes through impact printer yields undesirable results.
Handwritten copies are often misread, that means a typist must hand type
each report while reading the database. Pre-printed Form cannot be readily
redesigned.

Cannot a loop to store the field in variables then the variables be combined
by a string function into a single field to be printed in the detail be
written?
loop to countoflist
if memo null then goto last
variable=memo&variable
next loop
last prntfield=variable
variable=null

obviously, I am not a programmer, but surely you can see a possibility here.

 

[Rick B]

I would place the memo fields in a continuous report and place that as a
subreport into my main report where the rest of the data lives.

So, the section of your form where the comments scroll down the paper is to
be a sub report slapped in the middle of the other fields.

Hope that helps.

 

[David Smith]

Okay I am trying to make this work. It does look promising.

 

[John Nurick]

Assuming you have a 1:M relationship between whatever "governs" the
detail section and whatever you want to "consolidate", one standard
approach is to use a sub-report in the detail section of the main
report.

Otherwise, you could investigate using a function to concatenate the
values from the child records: there's one at
http://www.rogersaccesslibrary.com/OtherLibraries.asp#Hookom,Duane and
others at http://www.mvps.org/access.