Multicolumn Display

  • Thread starter Thread starter Steve
  • Start date Start date
S

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
 
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
Click to expand...

Select Number from tblNumber Where Used=False
Then what would it take to make it 3 columns with four rows in each column?
Click to expand...

You can do columns in reports, print setup.
 
Back
Top