Display Results Side by side

[Brianfree]

Hi, is it possible to display results side by side ie...

Normal results would be like...

1
2
3
4
5
6
7
8
9
10
11


Could it be displayed on a form like...

1 7
2 8
3 9
4 10
5 11
6

Many thanks,

Brian

 

[Remou]

You would need to create two subforms that selected a certain number of records for each form.

 

[Remou]

... unless a report would suit.

 

[Brianfree]

Hmmm... i can do it in asp for a webpage but can't figure it out on access... Will have a play...

Thanks..

 

[Remou]

Perhaps something on the lines of:

SELECT TOP 50 fld1, fld2 FROM tblT

SELECT TOP 50 fld1, fld2 FROM tblT WHERE id NOT IN (SELECT TOP 50 id FROM tblT)

 

[Brianfree]

Is it possible to put all the values into an array and just use the array item for a text box positioned on the form???

Regards,

BF

 

[Remou]

You could try GetRows, but you will need to look after edits and updates with code.