I have a rather tricky problem.
I have a dataset such as:
Code: Select all
ID Section Description
1 1 Red
2 1 White
3 1 Orange
4 1 Blue
5 2 Tan
6 2 Yellow
... ... ...
I need to create a simple query (that i can hopefully use in a simple form) that will sort it by it by Section, then by ID and concatenate the Descriptions together. Like this:
Code: Select all
Section Description
1 Red White Orange Blue
2 Tan Yellow
If anyone can help me, I would really appreciate it.
Thank you.