How to concatenate records from colunm Part2

[Mike]

Hi Guys
I run the membership Db for a charity and I am looking for a way to produce
a list of email addresses that I can use to send out the newsletter.
I have a master table TblMembers with a number of related tables that
contain information on Districts and qualifications.
I am looking at how to create a query that will produce the District Name in
One Column followed by a list of email addresses (Taken from the TblMaster,
Fd_Email) seperated by a ;
I have looked at the answers kindly provided in the past however I have now
realised that ALL the information that I need is actually in one table
(TblMembership) The information is gathered via a web interface. I am
trying to use Access to create a mailing list as stated so I am looking at a
simple way to run a query on the Tbl Membership that will extract all
members from a district and create a concatenated list of all the email
addresses for members in that district seperated by ;. I can then put the
result into the email form that I have already in Access (At the moment I
can only email a specific member).
Your assistance and guidance is appreciated.

Regards
Mike

 

[Piet Linden]

Hi Guys
I run the membership Db for a charity and I am looking for a way to produce
a list of email addresses that I can use to send out the newsletter.
I have a master table TblMembers with a number of related tables that
contain information on Districts and qualifications.
I am looking at how to create a query that will produce the District Namein
One Column followed by a list of email addresses (Taken from the TblMaster,
Fd_Email) seperated by a ;
I have looked at the answers kindly provided in the past however I have now
realised that ALL the information that I need is actually in one table
(TblMembership)  The information is gathered via a web interface.  I am
trying to use Access to create a mailing list as stated so I am looking at a
simple way to run a query on the Tbl Membership that will extract all
members from a district and create a concatenated list of all the email
addresses for members in that district seperated by ;.  I can then put the
result into the email form that I have already in Access (At the moment I
can only email a specific member).
Your assistance and guidance is appreciated.

Regards
Mike

fConcatChild() from www.mvps.org/Access will do that.
http://www.mvps.org/access/modules/mdl0004.htm