Multicolumn Display

[Steve]

Suppose you have a table like this:
TblNumber
NumberID
Number
Used Y/N

Suppose there are 10 numbers - none Used. How could a display like this in a
form be created:
1 6
2 7
3 8
4 9
5 10

Now suppose 3 and 4 are used. How could this be displayed in the same form:

1 8
2 9
5 10
6
7

Then what would it take to make it 3 columns with four rows in each column?

Thanks!

Steve

 

[Trevor Best]

Suppose you have a table like this:
TblNumber
NumberID
Number
Used Y/N

Suppose there are 10 numbers - none Used. How could a display like this in a
form be created:
1 6
2 7
3 8
4 9
5 10

Now suppose 3 and 4 are used. How could this be displayed in the same form:

1 8
2 9
5 10
6
7

Select Number from tblNumber Where Used=False

Then what would it take to make it 3 columns with four rows in each column?

You can do columns in reports, print setup.

 

[Steve]

Trevor,

Thanks for responding!

Any ideas on how to do it on a form?

Steve