ezfriend
Registered User.
- Local time
- Today, 05:50
- Joined
- Nov 24, 2006
- Messages
- 242
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
(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