Is this possible?

Joined
Apr 16, 2021
Messages
2
Reaction score
0
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
 

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