The following is the result set that I'm working with:
Code:
C6N	2.3875	2.3200	-4.0000	2.3300
C6U	2.5000	2.4375	-4.5000	2.4450
C6Z	2.6400	2.5775	-3.7500	2.5850
C7H	2.7450	2.6850	-4.2500	2.6925
C7K	2.8100	2.7625	-4.0000	2.7650
C7N	2.8850	2.8275	-3.7500	2.8350
C7Z	2.9600	2.9000	-3.2500	2.9075
C8H	3.0200	3.0000	-1.5000	3.0000
C8Z	3.1125	3.1125	.7500	3.1125
The first letter of the symbol is the commodity, the second is the year and the third is the month (H = March, Z = December, ect). The other fields are the high, lows, change and settlements.

For the report I'm making, I need the symbols in the first field to repeat horizontally on the report instead of vertically. Under each one, will be the details about that month.

The question I have is, is there a way (or a control) in access that I can use to change the orientation to display the results horizontally instead of vertically? The result I would like to see on the report is:
Code:
C6N	C6U	C6Z	C7H      ...
2.3875	2.5000	2.6400	2.6400   ...
2.3200	2.4375	2.5775	2.6850   ...
-4.0000	-4.5000	-3.7500	-4.2500  ...
2.3300  2.4450  2.5850  2.6925   ...
I plan on parsing the symbols so they're easier to read, but first I need to get over this hurdle.

Thanks in advance.