Continues Tabular Name Form

[sgtclark]

I am sure one of you super smart people have figured out acool way to do this!

I want to have a form that displays everyone name in tabularform on basically one sheet of paper. Of course tabular is column with eachrow. I can add a duplicate of that column, however it shows up as just that aduplicate. What I want is for the next column to pick up where the last ended.

I am thinking that there is some way to create a query that takes the first 25in a record sources and I can use some form of an expression to make a columnfor that group, and it take 26-50 and do the same for the second column, and soon and so on.

Column 1 Column2
John Doe LittleJohn
Jane Doe LittleJane

[CJ_London]

easy to do in a report - does it have to be a form?

you can try this query - change table and field names to suit. Based on max 50 persons in two columns of 25

SELECT A.Person, B.Person
FROM (SELECT TOP 25 P.PersonPK, P.Person, (SELECT Count(*) FROM tblPersons R WHERE PersonPK<=P.PersonPK) AS rs
FROM tblPersons AS P
ORDER BY P.PersonPK)  AS A LEFT JOIN (SELECT TOP 25 P.PersonPK, P.Person, (SELECT Count(*) FROM tblPersons R WHERE PersonPK<=P.PersonPK)-25 AS rs
FROM tblPersons AS P
WHERE (((P.PersonPK) Not In (SELECT TOP 25 PersonPK FROM tblPersons ORDER BY PersonPK)))
ORDER BY P.PersonPK)  AS B ON A.rs = B.rs

Edit: corrected the join from INNER to LEFT

[Bullschmidt]

And for the report here's an article that you may find helpful...

Microsoft Access Multi-Column Reports
http://www.databasedev.co.uk/multi-column_report.html