OR what about replacing the textbox with a subreport? Dawn Crosier "Education Lasts a Lifetime"
This message is posted to a newsgroup. Please post replies and questions to the newsgroup so that others can learn as well. -----Original Message----- From: [email protected] [mailto:[EMAIL PROTECTED] On Behalf Of Lonnie Johnson Sent: Saturday, August 19, 2006 7:30 AM To: [email protected] Subject: Re: [ms_access] Concatenate Result of a query What about putting a listbox in the report's footer? RAJESH DESAI <[EMAIL PROTECTED]> wrote: Hi, I have a report based on a query. The report is running fine and all the fields and calculations are fine. I have a field called Narration. Suppose my query fetches 4 records then I want to concatenate the Narrations from all the four records and show them in a Text Box or Lebel control at the bottom of the report. If possible all the four narrations should come in 4 rows in the text box or label control. I have tried several things, but it is not happening. Please help me in this. Thanks & regards, Rajesh Desai Yahoo! Groups Links <*> To visit your group on the web, go to: http://groups.yahoo.com/group/ms_access/ <*> To unsubscribe from this group, send an email to: [EMAIL PROTECTED] <*> Your use of Yahoo! Groups is subject to: http://docs.yahoo.com/info/terms/
