Results 1 to 4 of 4
  1. 06-20-2016, 10:58 PM #1
    msixpackabs
    msixpackabs is offline Novice
    Windows 7 64bit Access 2010 64bit
    Join Date
    Jun 2016
    Posts
    11

    Simple "all rows concatenate" no other criteria - ms access 2010

    I have this table containing all my e-mail recipients. E_MAIL_ADDRESSES
    Created two separate Queries: To and Cc (which depend on form selection).



    I want to simply concatenate all E_MAIL rows in E_MAIL_TO query and the same for E_MAIL_CC query.
    Please help ir I'm gonna be fired!

    e.g
    E_MAIL
    dan@1
    dan@2
    dan@3

    should become dan@1; dan@2; dan@3

    TY in advance
    Reply With Quote Reply With Quote
  2. 06-21-2016, 06:22 AM #2
    RuralGuy's Avatar
    RuralGuy
    RuralGuy is offline Administrator
    Windows 10 Access 2013
    Join Date
    Mar 2007
    Location
    8300' in the Colorado Rocky Mountains
    Posts
    12,917
    Maybe you will find this link useful: http://allenbrowne.com/func-concat.html
    Reply With Quote Reply With Quote
  3. 06-22-2016, 01:28 AM #3
    msixpackabs
    msixpackabs is offline Novice
    Windows 7 64bit Access 2010 64bit
    Join Date
    Jun 2016
    Posts
    11
    ty RuralGuy
    Reply With Quote Reply With Quote
  4. 06-22-2016, 05:03 AM #4
    RuralGuy's Avatar
    RuralGuy
    RuralGuy is offline Administrator
    Windows 10 Access 2013
    Join Date
    Mar 2007
    Location
    8300' in the Colorado Rocky Mountains
    Posts
    12,917
    Glad to help. Lots of success with your project.
    Reply With Quote Reply With Quote
Please reply to this thread with any new information or opinions.
« Previous Thread | Next Thread »

Similar Threads

  1. Access Pass Through Query to a Oracle Database using a simple "simple" inner friken join.
    By capjlp in forum Queries
    Replies: 8
    Last Post: 03-16-2016, 10:11 AM
  2. Trying to use a Sumif Style Statement in Access using a Concatenate Function
    By NathanGay in forum Queries
    Replies: 4
    Last Post: 03-04-2016, 10:08 AM
  3. Simple "Or is null" Criteria question
    By floyd in forum Queries
    Replies: 2
    Last Post: 11-22-2013, 10:05 AM
  4. Random "#NAME?" error being returned from DateAdd function in Access 2010 report
    By sljedwards in forum Access
    Replies: 7
    Last Post: 08-14-2013, 03:57 PM
  5. MS Access 2003/2007/2010: Error 97 "Can not call friend function..." and "There is no
    By 10Tec in forum Forms
    Replies: 2
    Last Post: 11-04-2011, 02:45 AM

Tags for this Thread

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

Forum Rules

Other Forums: Microsoft Office Forums