How to output query results formatted so that it prints in more of a bingo format than a list?

[kjb]

I have a simple query where the results produce one column of data.



Instead of it being output as one column, I have been asked to format it so that the list items go across the page, and the following items continue to fill up each row.

ie

A B C D E F G H
I J K L M N O P
Q....

instead of

A
B
C...

Thank you for your time.

kjb

[June7]

What are 'list items' and what are 'following items'?

You want the fields to wrap on 3 'rows'?

Your output example does not make sense to me. Show an example with field names and data.

[kjb]

An example of the output would be a list of user ids:

location
277AB
284ZZ
524KB
604TS
...

Instead of it showing in one column, as the list would be many pages, how can I make the output print more than one location per row (perhaps 10 per line), and then continue to fill the next line with the next locations in the list, etc.

thank you
kjb

[June7]

Is that the only field in your output?

Maybe a report formatted with multiple columns is what you want.

Otherwise, review: http://allenbrowne.com/func-concat.html

[kjb]

Yes, that is the only field in the output. They just want one big list of all the locations, across and continuing down the page (like words on a page of a book), instead of one column.

thank you
kjb

[June7]

Then build the multi-column report.

[kjb]

Thank you for your time.

kjb