Results 1 to 5 of 5
  1. #1
    rich is offline Novice
    Windows 7 64bit Access 2007
    Join Date
    Feb 2009
    Location
    St. John's, Newfoundland
    Posts
    14

    combining fields into a single list

    Working in Access 2007.

    I am working with an existing database that has members in a table with up to 3 e-mail addresses for each - these are in separate fields e-mail1, e-mail2 and e-mail3.



    I need a list of all e-mail addresses (that is a list of e-mail1, e-mail2 and e-mail3 combined into a single column). It does not need to contain any other information - its just to create a simple text file that I can upload to a listserv with everyone's e-mail address.

    I can't for the life of me figure out how to combine several fields into a single column list.

    Right now, I'm able to create a query of all e-mail addresses, but not surprisingly, it creates a three column list. I take these and put them into excel where I manually combine them into a single column and delete any blank cells. I want to automate the entire process so that I have a single text file with a list of e-mails.

    Hope this makes sense to someone.

  2. #2
    jya is offline Competent Performer
    Windows XP Access 2007
    Join Date
    Sep 2007
    Location
    Chicagoland
    Posts
    109
    Have you tried to concatenate?

    [e-mail1] & " " & [e-mail2] & " " & [e-mail3]

  3. #3
    rich is offline Novice
    Windows 7 64bit Access 2007
    Join Date
    Feb 2009
    Location
    St. John's, Newfoundland
    Posts
    14
    Concatenate might be part of the solution, but its not the answer - that would create up to three e-mails per column... I want one e-mail per column - all e-mail addresses in a single list.

    R.

  4. #4
    jya is offline Competent Performer
    Windows XP Access 2007
    Join Date
    Sep 2007
    Location
    Chicagoland
    Posts
    109
    I misinterpreted your question.

    Are you looking for something like this?

    Select [e-mail1] As "E-mail" from tblName Where [e-mail1] <> Null UNION ALL
    Select [e-mail2] As "E-mail" from tblName Where [e-mail2] <> Null UNION ALL
    Select [e-mail3] As "E-mail" from tblName Where [e-mail3] <> Null

  5. #5
    rich is offline Novice
    Windows 7 64bit Access 2007
    Join Date
    Feb 2009
    Location
    St. John's, Newfoundland
    Posts
    14
    Sorry for delay... off sick for a couple of days.

    This works perfectly. Thanks for your help.


    R.

Please reply to this thread with any new information or opinions.

Similar Threads

  1. Searching for a single word in all table
    By rielcas in forum Access
    Replies: 1
    Last Post: 06-19-2013, 06:28 AM
  2. Replies: 5
    Last Post: 03-23-2011, 10:39 AM
  3. Replies: 0
    Last Post: 08-13-2008, 03:15 PM
  4. Adding a single record
    By kfoyil in forum Forms
    Replies: 2
    Last Post: 11-22-2006, 09:12 PM
  5. Replies: 1
    Last Post: 06-03-2006, 05:02 PM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums