another query challenge

[Raphael Crawford-Marks]

I have a table that looks like this:

Field1 |Field2 |Field3
123 |6/2/98 |n
123 |1/21/98 |b
123 |2/2/98 |3
123 |1/12/98 |c
123 |1/2/98 |2
345 |4/2/98 |a
345 |3/23/98 |b
345 |1/2/98 |y
678 |12/2/98 |x

I need to write a query that gives me this

Field1 |1st F2 |1st F3 |2nd F2 |2nd F3 |3rd F2...
123 |6/2/98 |n |1/21/98 |b |2/2/98...
345 |4/2/98 |a |3/23/98 |b |1/2/98...
678 |12/2/98 |x | | | ...

As you can see, I want to group by Field1, and then have a
pair of columns for each corresponding record. There are
at most 12 records for each unique entry in Field1, so I
know there won't be an unmanageable number of queries.
I've looked into the Choose() function and crosstab
queries, and it doesn't seem like either of these can do
this...

Thanks,
Raphael