Hello all,

How to merge memos from many records to become 1 record ?

mytable :
empno memo
11111 memo1
11111 memo2
11111 memo3

22222 memo4
22222 memo5
22222 memo6

Newtable :

11111 memo1+memo2+memo3
22222 memo4+memo5+memo6

in order to have a report like :
-----------------------------------------------------------
empno : 11111

Memo :
memo1
memo2
memo3
....
....
until the end of page or maybe skip to the new page if
have large memos to print.

-----------------------------------------------------------
empno : 22222

Memo :
memo4
memo5
memo6

------------------------------------------------------------

Thanks,
PP