Multiple Columns In A Form

[overdraft015]

is there any way that i can have multiple columns within a form using the same data so that it carries on when the space runs out?


thank you,

Michael

 

[Remou]

This sounds like your data is not normalized. Perhaps you can explain a little further?

 

[overdraft015]

i have created a little program that checks some imported data against a table. i then would like to show the results to ensure both datas match. i will only need to show. product, qty, status (i.e. matching or not)and seeing as its only 3 colums it seems a waste of space for the user to have to scroll down when i can easily make 3 columns so it all fits on 1 screen?

 

[Remou]

I suppose you could use subforms with queries that select a certain number of records. If it is not necessary to edit the data, a report with one or more columns may suit.

 

[overdraft015]

i will try subforms each with a limited number of recordsets

Thank you

 

[randy700]

Use subforms / subreports based on queries, something like this...

1st column

SELECT TOP 25 Customer FROM myTable

2nd column

SELECT TOP 25 Customer FROM myTable
WHERE Customer NOT IN
(SELECT Top 25 Customer FROM myTable)

3rd column

SELECT TOP 25 Customer FROM myTable
WHERE Customer NOT IN
(SELECT TOP 50 Customer FROM myTable)

You can substitute the query names for the sub-queries if you prefer...

SELECT TOP 25 Customer FROM myTable
WHERE Customer NOT IN
(SELECT Customer FROM myFirstQuery)

Randy