Hi Can someone please help me.
I have two tables in my database a complaint table and a resolution table. One complaint may have several resolutions. I am trying to build a report that will give me the complaint details and all the resolution descriptions for a complaint in one text area/row (concated together). At the moment it is repeating the complaint details for each resolution. Any help would be gratefully received Cheers Liz ---------------------------(end of broadcast)--------------------------- TIP 4: Don't 'kill -9' the postmaster