Print results in a matrix form

[sheela]

I need help in designing a report ASAP. I am using ACCESS
2002 version.
This report record source is from a query (based on one
table). I need to show the information in a matrix form (9
by 9) with 81 cells. Some thing like below.
1 2 3 .. 9
10 11 ..
... .. .. .. ..
73 74 81

There is field called "POSITION" in the source records,
whose values run from 1 through 81. If the POSITION value
is 1, the report shows some other fields values in cell 1.
If there is no 1 exist for POSITION in the query results,
the cell 1 is set to NULL. Same criteria for the remaining
80 cells.
I am planning the following; I would appreciate if
somebody could give any input/suggestions.

I add 81 text Boxes to the report for 81 cells and in
the "Report Open" method, I will use the code:
Me!text1.text= iif([POSITION] =1, [FIELDNAME]," " )
....
But it's not working. Could some one help me with this
problem?
TIA,
Sheela.

 

[Duane Hookom]

You would never use the "text" property of a text box. Do you always have
position values of 1 through 81 in separate records? If not, I suggest that
you create a lookup table that contains the values 1 through 81. Add this
table to the record source of your report and set the join between the
number field to your Position field to show all the records from your lookup
table.

Then set the report to be 9 columns wide (Page|Setup) and make sure it
sorts on the number field from your lookup table. This will create a 9x9
matrix.

 

[sheela]

Yes, you are correct, The POSITION field doesn't always
have values 1 through 81. I was looking for help to create
look up table, coudn't find it. I am sorry to post this
question here. Could you please give me a hint on creating
look up tables.
Thanks so much,
Sheela

-----Original Message-----
You would never use the "text" property of a text box. Do you always have
position values of 1 through 81 in separate records? If not, I suggest that
you create a lookup table that contains the values 1 through 81. Add this
table to the record source of your report and set the join between the
number field to your Position field to show all the records from your lookup
table.

Then set the report to be 9 columns wide (Page|Setup) and make sure it
sorts on the number field from your lookup table. This will create a 9x9
matrix.

--
Duane Hookom
MS Access MVP
--

I need help in designing a report ASAP. I am using ACCESS
2002 version.
This report record source is from a query (based on one
table). I need to show the information in a matrix form (9
by 9) with 81 cells. Some thing like below.
1 2 3 .. 9
10 11 ..
.. .. .. .. ..
73 74 81

There is field called "POSITION" in the source records,
whose values run from 1 through 81. If the POSITION value
is 1, the report shows some other fields values in cell 1.
If there is no 1 exist for POSITION in the query results,
the cell 1 is set to NULL. Same criteria for the remaining
80 cells.
I am planning the following; I would appreciate if
somebody could give any input/suggestions.

I add 81 text Boxes to the report for 81 cells and in
the "Report Open" method, I will use the code:
Me!text1.text= iif([POSITION] =1, [FIELDNAME]," " )
...
But it's not working. Could some one help me with this
problem?
TIA,
Sheela.

.

 

[Duane Hookom]

Just create a table "tblAllPositions" with a field "PositionNum" and add
values/records 1 - 81.

--
Duane Hookom
MS Access MVP
--

Yes, you are correct, The POSITION field doesn't always
have values 1 through 81. I was looking for help to create
look up table, coudn't find it. I am sorry to post this
question here. Could you please give me a hint on creating
look up tables.
Thanks so much,
Sheela

-----Original Message-----
You would never use the "text" property of a text box. Do you always have
position values of 1 through 81 in separate records? If not, I suggest that
you create a lookup table that contains the values 1 through 81. Add this
table to the record source of your report and set the join between the
number field to your Position field to show all the records from your lookup
table.

Then set the report to be 9 columns wide (Page|Setup) and make sure it
sorts on the number field from your lookup table. This will create a 9x9
matrix.

--
Duane Hookom
MS Access MVP
--

I need help in designing a report ASAP. I am using ACCESS
2002 version.
This report record source is from a query (based on one
table). I need to show the information in a matrix form (9
by 9) with 81 cells. Some thing like below.
1 2 3 .. 9
10 11 ..
.. .. .. .. ..
73 74 81

There is field called "POSITION" in the source records,
whose values run from 1 through 81. If the POSITION value
is 1, the report shows some other fields values in cell 1.
If there is no 1 exist for POSITION in the query results,
the cell 1 is set to NULL. Same criteria for the remaining
80 cells.
I am planning the following; I would appreciate if
somebody could give any input/suggestions.

I add 81 text Boxes to the report for 81 cells and in
the "Report Open" method, I will use the code:
Me!text1.text= iif([POSITION] =1, [FIELDNAME]," " )
...
But it's not working. Could some one help me with this
problem?
TIA,
Sheela.

.