Split rows to 2 columns

[kuipers78]

Hello,

Is it possible to split rows of a single column into 2 (new) columns by using a query? Example: column A from a table contains 200 (unique) rows and the query divides them (dynamically) to column B and C with 100 unique rows each.

Why would you do that? Well, because I want the table to be displayed in my (continuous) report, but because it contains so many records, I want to display them in two columns next to each other. When I do that by putting the table field twice in my detail section, I get two identical columns...

 

[neileg]

Why not just do a multi column report?

 

[kuipers78]

Don't I have to split my single table column first to do that?

 

[neileg]

Have a look at the Access help files. No you don't need to split your data. If you want part of the report multi column and part single column, a sub report may be the answer here.