Merge non blank records

[poporacer]

I have a report that is derived from a table (tblDocs) the structure of the table is:

EmpId docType docDate comments
(number) (number) (Date) (text)

This table will have several entries for each employee. There will only be a few times that a comment will be entered. On my report, I will have a field for the comments and I would like ALL of the comments for each employee combined into one text box in the report There will be blank entries in most of the records). I think the control source for this might be a query, but not sure. I set the properties of the text box to can grow.

I am not sure where to start...

 

[JHB]

Take a look at the thread
http://www.access-programmers.co.uk/...d.php?t=248376 post #6, it is exactly the same you are asking for. The Names = yours "comments" and the Address = yours "employee".

 

[poporacer]

hmmm. I try to open it up and get an unrecognized database format. I have access 2007. It sounds a lot like what I need to do. So I would create this table each time I go to print the report?

 

[JHB]

Here is it in a mdb format.