Lets say I have an Access 2007 database table with two fields called MyNumber and MyText.
There are seven records as follows:
1 A
1 B
1 C
2 D
2 E
2 F
I need to write a query that returns two rows:
1 A B C
2 D E F
How would I do that? I have no idea how to even start.
