More than one data in a field! HELP!

M

MIRAccess

I am having a problem. I want to create a mailing list from a query and would
like to include all the email addresses for specific positions in one field.
That is, for CEO I want to list all the contact email address with the job
function CEO in just one field (column).

I have a query that looks like this:
Contact Name Job Functions Email Address
Jane Doe CEO [email protected]
John Doe CEO [email protected]
John Public CFO [email protected]
John Crow CIO [email protected]

I would like to create a table from this that shows the CEO and all their
email addresses in one column so that I can create a hypelink for an email
which will send to all the different email address in one click but just for
specific job functions such as CEO, etc.

Can someone please help???
Thanks.
 
J

John W. Vinson

I am having a problem. I want to create a mailing list from a query and would
like to include all the email addresses for specific positions in one field.
That is, for CEO I want to list all the contact email address with the job
function CEO in just one field (column).
Click to expand...

You don't need to, or want to, have a Table Field containing multiple values.
What you can do instead is concatenate the values from multiple records into
one calculated field. See

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

for code to get you started with this.
 
M

MIRAccess

Thanks for your help but I can't open this document. I am getting an error
message that says unrecognized database format even when I try opening with
Access 2000. Can you please help with getting this open.

Thanks.
 
M

MIRAccess

Duane...I got it, there were some issues with my Access. I got it to open now.

Thanks for your help.
 
Top