field value concatenation VBA

Discussion in 'Access General' started by, 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. Advertisements

  2. The Access Web has some code for this:


    John W. Vinson [MVP]
    Microsoft's replacements for these newsgroups:
    and see also
    John W. Vinson, Mar 19, 2013
    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.