Using Array to Display column horizontally instead of vertically

[BatmanMR287]

I have a report that needs to display information from a column (eight members) horizontally.

Ted Smith John Sampson Ricky Bobby

Unfortunately access likes to display data in a column vertically.

Ted Smith
John Sampson


Ricky Bobby

Each person has a composite key for their group and for each individual. The individual number is an auto number.
What I want to do is populate an array with the individual numbers and then be able to display each one at a time horizontally across the report as in the top example.
This is a report that must be one button so setting a drop down box to select each one at a time is not an option.
I need help writing the code.

[ItsMe]

I would try to build a query that spit out the results I needed, vertically. Then I would use that query to populate controls in a Report. So probably, the query would be separate from the RecordSource of the report and the TextBox Controls would be Unbound.

9 times out of 10 you will find a way to place the data into a table or use a query before there is a need for an Array. Here is an example of a multidimensional array the I keep in my notes for reference. It is not very intuitive but if you stare at the code it might start to make sense.

[June7]

You want the names as column headers? What you want might be possible with CROSSTAB query. Otherwise, options:

1. http://allenbrowne.com/func-concat.html

2. https://www.accessforums.net/program...ias-21972.html

[Micron]

Could you not use a crosstab query?
Hope Y'all will forgive me if I repeat what's contained in the sample files, but I don't wish to download and set them up. I did check the links though, and think I method I learned is different. The AB version will concatenate the csv data into one field/control, n'est pas? The method I have in mind will take one field of data (rows) and spread each value across columns in a new query. Just so happens that for my case, the number was eight also. However, if that changes, you're looking at a fair bit of re-design. For my project, the array is also stored in a table as csv, and de-constructed when needed. The basics of the method are:
- create a normal query to get the required data
- open a recordset on this query, loop through, and build a csv array
- create a function that will get the nth value from the array (Split function)
- in another query, eight fields call the function as getWhatever(1), getWhatever(2), etc.
An action such as form/report opening causes the code to start at the first step listed above and the output of the second query is the recordset for the form/report.

Let me know if this sounds useful, but do check out the other suggestions posted first. It's a lot of work.