You must have a field that the group is based on. Let's assume the field name to group the fields is is 'grp' (all records in the first group might have a '1' in that field, the 2nd group every record will have a '2' etc and the cursor name is 'test'. Let's assume the memo field is named 'notes' :

1. Under Report, Datagrouping (on the menu), add a group: test.grp
2. Go to the variable setup for the report
3. Create a report variable named lcnotes
4. set the value to store as lcnotes+test.notes
5. set the initial value = ""
6. set the reset value based on to group: test.grp
7. Put a field object in the group footer of the report
8. for the field's expression put lcnotes
9. click on 'stretch with overflow' under the field properties

preview the report.


>Thanks. Could you give a little more help to the specifics?
>There are no fields in the header of the group nor are there any fields in the detail section.
>Not sure how to pull this off in Foxpro.
>Easy in Crystal Reports for me.
>
>
>>There are probably a few ways to do this. You could step through the cursor used for the report and build a string of all the memo data in the group. When you get to the last record in that group, stuff the string into it's memo field. Or add a new 'last' record for that group an put it in there. Or you could create a report variable to store it and then display that variable in the group's footer - reset the variable at the start of each group.
>>
>>
>>>In the report writer is it possible to combine several records of the same memo field and show the contents once at the end of a group?
>>>
>>>Example:
>>>Rec #1 Memo field has abcdef
>>>Rec #2 Memo field has ghijkl
>>>Rec #3 Memo field has mnopqr
>>>
>>>At end of group shows abcdefghijklmnopqr
>>>
>>>In Crystal I would make a var at top of group
>>>in detail add to it Var=Var+memo
>>>At end of group I would show the contents
>>>But I could suppress the field and section in Crystal
>>>
>>>Not sure how to do it in Foxpro
>>>
>>>
>>>Andy