Lets say I have a table in an Access 2007 database with 2 fields: MyNumber & MyText
The entires are as follows

1 A
1 B
1 C
2 D
2 E
2 F

and I need to run a query that will display

1 A B C
2 D E F

How would I do that? I have no idea where to start.