field value concatenation VBA

Discussion in 'Access General' started by ktown4989@gmail.com, Mar 19, 2013.

  1. Guest

    i have several hundreds of records with the duplicate email addresses in a field, but different value in another field.

    such as..

    unique email value new value
    --------------------------------------------
    yes sample_email01 a1
    no sample_email02 ge
    no sample_email03 a2


    I want in a record with unique value 'yes' to have "a1 ge a2" in 'new value' field.

    can anyone tell me how i can realize this using vba code.. I have several hundreds of records with many emails... but only about one third of unique email addresses..

    with each unique email, i want to update 'new value' field with values in 'value' field with the same email.

    any help will be deeply appreciated.
     
    , Mar 19, 2013
    #1
    1. Advertisements

  2. The Access Web has some code for this:

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

    --

    John W. Vinson [MVP]
    Microsoft's replacements for these newsgroups:
    http://social.msdn.microsoft.com/Forums/en-US/accessdev/
    http://social.answers.microsoft.com/Forums/en-US/addbuz/
    and see also http://www.utteraccess.com
     
    John W. Vinson, Mar 19, 2013
    #2
    1. Advertisements

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments (here). After that, you can post your question and our members will help you out.