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.