stormin_norm
Registered User.
- Local time
- Today, 05:03
- Joined
- Apr 23, 2003
- Messages
- 213
Report using sql in VBA vs. query
Before I go down this path, I want to get some input from some experts.
In the queries discussion, I am seeking to create a parameter form which pulls up a base query and then creates a crosstab query for use in a report.
the idea is: param frm->qry 4 tables-->crosstab qry-->report
I believe the only way to create the ability for dynamic header info on a report is through the sequence:
param frm->qry 4 tables->event on open report ->vba code to format data -> display report
http://www.access-programmers.co.uk/forums/showthread.php?s=&threadid=50969
I'm having trouble dynamically creating the column headers before running the crosstab query. My only other idea is to code everything the report using VBA. And therfore no need for a crosstab, I simply run some loops to create the matrix.
looks like:
Courses: MGT401 MGT402 MGT403
Students:
Smith, Joe A B B
Sly, Robbie B B+
-thanks.
Before I go down this path, I want to get some input from some experts.
In the queries discussion, I am seeking to create a parameter form which pulls up a base query and then creates a crosstab query for use in a report.
the idea is: param frm->qry 4 tables-->crosstab qry-->report
I believe the only way to create the ability for dynamic header info on a report is through the sequence:
param frm->qry 4 tables->event on open report ->vba code to format data -> display report
http://www.access-programmers.co.uk/forums/showthread.php?s=&threadid=50969
I'm having trouble dynamically creating the column headers before running the crosstab query. My only other idea is to code everything the report using VBA. And therfore no need for a crosstab, I simply run some loops to create the matrix.
looks like:
Courses: MGT401 MGT402 MGT403
Students:
Smith, Joe A B B
Sly, Robbie B B+
-thanks.
Last edited:
