Combine duplicate rows

[ezfriend]

Have a query the return the search result as follow.
(note that I have thousands of rows as the query results)

ID Name DateEntered Comments
----------------------------------------
1 Joe Johnson 2/2/2009 Comment1
1 Joe Johnson 2/2/2009 Comment2
1 Joe Johnson 2/2/2009 Comment3

What I have right now is to have the query returns a distinct list of just ID, Name, and DateEntered. As each record is loaded to the report, I call a function to get the different comments for each record using the ID field and then populate the unbounded text field on the report.

This is such a drag since I have a lot of records. What's the best way to deal with this?

Thanks for any suggestions.

EZ

 

[SOS]

Get rid of the comments in your query for the report. Then create a query with just the comments (along with ID and date entered). Create a SUB REPORT and put it into your report, linking on the ID and Date.

 

[ezfriend]

Thanks. I'll give that a try and see if that will improve the performance.

 

[gemma-the-husky]

why bother with distinct rows in the query, if you need to get the comments. just include the comment in the query