field value concatenation VBA

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

 

[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