Forum Discussion
Is this possible?
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 ...
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! 😞
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