Distribute records list in many columns?

[CharlyAR]

I have a recordset that gives me a list of about 20~30 records, and I want them in two columns of 10~15 records each.

Anybody could tell me how to do it? I've no ide... :(

Tnx!

[big_old_bird]

Hi

You could try something like this:

query for first list

select top 15 * from table
order by X

Query for second list

select top 15 * from table where X not in (select top 15 X from table)
order by X

I hope that makes sense! it did when I thought it lol!!!

Karen