Display results horizontally?

[Nitesh9999]

Hi, is there anyway to display the results horizontally?

if these are the results of my query

Results
2
2
3
4
6
8

Normally they would be diplayed just like that in the report. What I would like is to have them displayed like this:

Results
2 2 3 4 6 8

 

[KenHigg]

How many rows will you have?

Ken

 

[Nitesh9999]

Either 12 or 24. possibly 15 or 27. Does this alter if it can or cannot be done?

 

[KenHigg]

Well, my first thought is that you could just put this in an array or maybe concatenate. But then again, it seems like a lot of trouble if you only have that many rows...

Ken

fyi - I can't think of any simple tricks - Sorry...

 

[Nitesh9999]

Sorry im being a fool!!

I'm going to have alot more ROWS than that but 12-24 fields. Not quite sure how many rows in total but 100+.

 

[KenHigg]

Hum... The only thing else that I can think of is using the report page setup to do col's.


Ken

 

[Nitesh9999]

I'll have a look, thanks. Another forum recommended cross tab queries.