Rajesh If I really get you right, you can achieve what your want by using VBA i.e. your report must be based on a VBA recordset. What I mean is in VBA open a recordset with all your criteria. If the recordset is not null loop through the records, concatenate the Narrations into a string (at the end of each Narration put "& Chr(10)" and "& Chr(13)" for carriage return and line feed). The Narration string should be the Control Source for your report textbox or the caption of your report label. However, in your explanation you give an example of 4 records being fetched what happens when you have more records than can fit on one page? HTH Liveson
_____ From: [email protected] [mailto:[EMAIL PROTECTED] On Behalf Of RAJESH DESAI Sent: Saturday, 19 August, 2006 11:54 AM To: Access2 Subject: [ms_access] Concatenate Result of a query 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 --------------------------------- Here's a new way to find what you're looking for - Yahoo! Answers Send FREE SMS to your friend's mobile from Yahoo! Messenger Version 8. Get it NOW [Non-text portions of this message have been removed] [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/
