Hi guys,
I'm trying to create a crosstab report.
So far I've created the actual report with no Record Souce with a page header containing text boxes named "head1", "head2" etc through to "head15". In the detail section I have "col1" to "col15" and in the page footer I have "tot1" to "tot15".
I have added the results of the crosstab query to a recordset and written the VB code to get it to add the values to the correct "head#" text boxes and the same for the "col#" boxes.
My problem is that whilst I can use the "rstReport.MoveNext" command to move to the next row of the recordset, it keeps overwriting the same line in the report with the next line of the recordset. What function do I need to use to force the report to add a new row before entering the next row of the recordset?
Many thanks in advance.
I'm trying to create a crosstab report.
So far I've created the actual report with no Record Souce with a page header containing text boxes named "head1", "head2" etc through to "head15". In the detail section I have "col1" to "col15" and in the page footer I have "tot1" to "tot15".
I have added the results of the crosstab query to a recordset and written the VB code to get it to add the values to the correct "head#" text boxes and the same for the "col#" boxes.
My problem is that whilst I can use the "rstReport.MoveNext" command to move to the next row of the recordset, it keeps overwriting the same line in the report with the next line of the recordset. What function do I need to use to force the report to add a new row before entering the next row of the recordset?
Many thanks in advance.
