I have an access table including these fields:
Name TestName Results%
I would like to produce the following report:
TestName1 TestName2 TestName3...
Name1 % % %
This can be produced easily in Access using a crosstab query but when trying
this with VB the fun begins!
I can copy the SQL into a command in a data environment and use this to produce
the data report, which is fine.
But the two major problems I just can't get around are:
1) I don't know until run-time which names I want in the report.
2) I don't know until run-time which tests to include in the report.
any idea as to how to get round this