DorisH3 at aol.com
DorisH3 at aol.com
Wed Nov 23 20:59:16 CST 2005
I am fairly new to Access, so I apologize ahead of time for my incompetence. I have a report that I need to put together which shows the First and Last Names of Volunteers and their qualifications...I need to show as an example: Last Name First Name Qualifications Smith Ann BB, CC, MF, Jones Richard CF, CT I have 2 tables....one for the volunteers which contains VolNum, FirstNm, LstNm,Addr,City,St,Zip and then I have a 2nd table which contains VolNum and QualificationCode. Because the volunteers are qualified in more than one area their could be several records for one volunteer in the Qualifications table. My problem is how do I show the last column of the report with commas after each record from the Qualifications table vs listing each qualification on a seperate line for the volunteer. Thanks ahead of time for the assistance. Doris