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