More than one data in a field! HELP!

[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 (e-mail address removed)
John Doe CEO (e-mail address removed)
John Public CFO (e-mail address removed)
John Crow CIO (e-mail address removed)

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.

 

[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).

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.

 

[Duane Hookom]

The generic concatenate function at
http://www.rogersaccesslibrary.com/forum/forum_posts.asp?TID=16 might be what
you need.

 

[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.

 

[MIRAccess]

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

Thanks for your help.