Lets say I have an Access 2007 database table with two fields called MyNumber and MyText.
There are seven records as follows:
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.