[AccessD] Need help

...this is a sample module which does what you want to do ...you'll have to 
rewrite the code to address your tables, fields, and relationships but the 
functionality you need is all there.

http://www.mvps.org/access/modules/mdl0004.htm

William

----- Original Message ----- 
From: <DorisH3 at aol.com>
To: <accessd at databaseadvisors.com>
Sent: Wednesday, November 23, 2005 9:59 PM
Subject: [AccessD] Need help


>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
> -- 
> AccessD mailing list
> AccessD at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com
>