field value concatenation VBA

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

  1. ktown4989

    ktown4989 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.
    ktown4989, 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.