String several Comments into a single Control Field.

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a report that may have several Records any of which could be a Repair
or Rejection. Whenever a Repair or Rejection occurs, the Inspector will put a
short comment in a Comment control to explain the reason. Since I count the
number of Repair and Reject records, I would also like to be able to gather
all these comments and add them to a single comment field at the bottom of
the report. Something like this: "Cut Crooked, Out of Square, Too Short,
ect.". There has to be a way to do this but at this point I have gotten
myself lost and can't find anything like it in any of the other Posts. Any
help would be much appreciated. Thanks in advance. Hoopster
 
Search this or other Access news groups on "Concatenate records".
A good place to search is at Google Groups.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Concatenate many to one 5
Interactive report - insert comment (like Excel)? 1
Creating a Dialog box to enter comments in a report 1
Grouping comments by survey question 1
Conditional Printing of Comment Line 3
Select Distinct subquery in a Report Control? 1
Comments Field 1
Using a Union query in a subreport 2

Back
Top