Is this possible?

%3CLINGO-SUB%20id%3D%22lingo-sub-2450253%22%20slang%3D%22en-US%22%3EIs%20this%20possible%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2450253%22%20slang%3D%22en-US%22%3E%3CP%3EHello%2C%20I%20have%20in%20a%20Table%203%20fields%20named%3A%20CODE%2C%20VALUE%2C%20VS%2C%3C%2FP%3E%3CP%3EThey%20have%20the%20following%20form%3A%3C%2FP%3E%3CP%3E%3CU%3ECODE%3C%2FU%3E%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%3CU%3EVALUE%3C%2FU%3E%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%3CU%3EVS%3C%2FU%3E%3C%2FP%3E%3CP%3EWER77%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B3658%3C%2FP%3E%3CP%3EWER77%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B495A%3C%2FP%3E%3CP%3EWER77%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B6215%3C%2FP%3E%3CP%3ELL5489%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B7Q88%3C%2FP%3E%3CP%3ELL5489%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B3856%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ESo%20as%20you%20see%20the%20field%20%22CODE%22%20has%20many%20similar%20entries.%20But%20each%20similar%20entry%20has%20a%20different%20entry%20in%20the%20field%20%22VALUE%22.%20What%20I%20need%20is%20the%26nbsp%3B%20%22VALUE%22%20entries%20of%20the%20same%20%22CODE%22%2C%20to%20be%20entered%20in%20the%20field%20%22VS%22%2C%20comma%20separated%2C%20in%20the%20first%20record%20of%20each%20common%20CODE%20entry.%20So%20the%20above%20example%20would%20look%20like%3A%26nbsp%3B%3C%2FP%3E%3CP%3E%3CU%3ECODE%26nbsp%3B%3C%2FU%3E%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%3CU%3EVALUE%3C%2FU%3E%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%3CU%3EVS%3C%2FU%3E%3C%2FP%3E%3CP%3EWER77%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B3658%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B3658%2C%20495A%2C%206215%3C%2FP%3E%3CP%3EWER77%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B495A%3C%2FP%3E%3CP%3EWER77%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B6215%3C%2FP%3E%3CP%3ELL5489%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B7Q88%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%207Q88%2C%203856%3C%2FP%3E%3CP%3ELL5489%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B3856%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EIs%20this%20possible%3F%20Sorry%20if%20I%20didn't%20explain%20it%20well%2C%20but%20English%20is%20not%20my%20main%20language.%3C%2FP%3E%3CP%3EThank%20you%3C%2FP%3E%3CP%3EDimitris%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2450253%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EAccess%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2451555%22%20slang%3D%22en-US%22%3ERe%3A%20Is%20this%20possible%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2451555%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F1028318%22%20target%3D%22_blank%22%3E%40DimitrisGreece%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3EYes%2C%20as%20theDBGuy%20explained%20in%20response%20to%20%3CA%20href%3D%22https%3A%2F%2Fanswers.microsoft.com%2Fen-us%2Fmsoffice%2Fforum%2Fall%2Fis-this-possible%2F96be763c-07c4-47d1-8567-ebac15c62bf4%22%20target%3D%22_self%22%20rel%3D%22noopener%20noreferrer%22%3Eyour%20question%20about%20this%20at%20MS%20Answer%3C%2FA%3Es%2C%20you%20can%20use%20%3CA%20href%3D%22http%3A%2F%2Fwww.accessmvp.com%2Fthedbguy%2Fcodes.php%3Ftitle%3Dsimplecsv%22%20target%3D%22_self%22%20rel%3D%22nofollow%20noopener%20noreferrer%22%3Ea%20function%20that%20concatenates%20those%20values%20into%20a%20single%20field%20in%20a%20query.%26nbsp%3B%3C%2FA%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EAs%20I%20said%2C%20you%20can%20do%20this%20to%20DISPLAY%20those%20concatenated%20values%20as%20needed%20for%20a%20query%20or%20a%20report%2C%20but%20it%20is%20not%20appropriate%20to%20store%20them%20that%20way%20in%20a%20table.%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2452327%22%20slang%3D%22en-US%22%3ERe%3A%20Is%20this%20possible%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2452327%22%20slang%3D%22en-US%22%3EThanks%20for%20your%20answer.%20I%20couldn't%20make%20this%20work.%20I%20am%20a%20newbie%20in%20Access%2C%20and%20I%20couldn't%20adjust%20that%20code%20to%20my%20table.%20Actually%20I%20didn't%20understand%20anything!%20%3A(%3C%2Fimg%3E%3C%2FLINGO-BODY%3E
New Contributor

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

3 Replies

@DimitrisGreece 

Yes, as theDBGuy explained in response to your question about this at MS Answers, you can use a function that concatenates those values into a single field in a query. 

 

As I said, you can do this to DISPLAY those concatenated values as needed for a query or a report, but it is not appropriate to store them that way in a table. 

Thanks for your answer. I couldn't make this work. I am a newbie in Access, and I couldn't adjust that code to my table. Actually I didn't understand anything! :(

@DimitrisGreece 

In the other thread, we discussed that this is ONLY useful for DISPLAY of those fields and values in a query, and not to be used to create a non-standard kind of table that will end up making life more difficult.

It would help to provide you some more detailed help if you can provide some sample data in a sample accdb. This forum supports upload of files so we could use it to fine-tune that query