field value concatenation VBA


K

ktown4989

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.
 
J

John W. Vinson

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

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. After that, you can post your question and our members will help you out.

Ask a Question

Top