I am trying to create a list of the data instead of a space hogging report fashion.
Here is sample data:
Name Letter Number
name1 a 1
name1 a 2
name1 b 1
name1 b 2
name1 b 3
The letters and numbers don't relate to each other and I would like this broken down to a single line:
name1 a b 1 2 3
Imagine I have hundred of names each consisting of multiple letters and numbers. Any Access generated reports would be huge if each name took a dozen lines or so. If I can get each name to take its own line, the reports would be manageable.
Thanks!