Many people have given their suggestions but I haven't read any feedback from Rajesh who initiated this thread. Rajesh, is your problem over? If not, what have you done so far and where are you stuck? If the problem is over please tell us lest we continue scratching our heads for solutions in vain. Regards Liveson
_____ From: [email protected] [mailto:[EMAIL PROTECTED] On Behalf Of Dawn Crosier Sent: Monday, 21 August, 2006 10:24 PM To: [email protected] Subject: RE: [ms_access] Concatenate Result of a query 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:ms_access%40yahoogroups.com> ps.com [mailto:[EMAIL PROTECTED] <mailto:ms_access%40yahoogroups.com> ps.com] On Behalf Of Lonnie Johnson Sent: Saturday, August 19, 2006 7:30 AM To: [EMAIL PROTECTED] <mailto:ms_access%40yahoogroups.com> ps.com Subject: Re: [ms_access] Concatenate Result of a query What about putting a listbox in the report's footer? RAJESH DESAI <[EMAIL PROTECTED] <mailto:rmdesai73%40yahoo.com> com> 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 [Non-text portions of this message have been removed] 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/
