[AccessD] Need help

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



More information about the AccessD mailing list