Hello, I have in a Table 3 fields named: CODE, VALUE, VS,
They have the following form:
CODE VALUE VS
WER77 3658
WER77 495A
WER77 6215
LL5489 7Q88
LL5489 3856
So as you see the field "CODE" has many similar entries. But each similar entry has a different entry in the field "VALUE". What I need is the "VALUE" entries of the same "CODE", to be entered in the field "VS", comma separated, in the first record of each common CODE entry. So the above example would look like:
CODE VALUE VS
WER77 3658 3658, 495A, 6215
WER77 495A
WER77 6215
LL5489 7Q88 7Q88, 3856
LL5489 3856
Is this possible? Sorry if I didn't explain it well, but English is not my main language.
Thank you
Dimitris
They have the following form:
CODE VALUE VS
WER77 3658
WER77 495A
WER77 6215
LL5489 7Q88
LL5489 3856
So as you see the field "CODE" has many similar entries. But each similar entry has a different entry in the field "VALUE". What I need is the "VALUE" entries of the same "CODE", to be entered in the field "VS", comma separated, in the first record of each common CODE entry. So the above example would look like:
CODE VALUE VS
WER77 3658 3658, 495A, 6215
WER77 495A
WER77 6215
LL5489 7Q88 7Q88, 3856
LL5489 3856
Is this possible? Sorry if I didn't explain it well, but English is not my main language.
Thank you
Dimitris