String several Comments into a single Control Field.

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
 
D

Duane Hookom

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

Top