I need the 'result' of a test to show in the 'testName' field

P

PITB1

I need to display a test result from a 'result' field under the name of the
test that has become a column by making a Crosstab Query. There are up to 6
different results per person and there are over 400 tests. Any suggestions???
 
M

[MVP] S.Clark

The Short answer is that VBA can probably solve it, or maybe another couple
of queries, or maybe even a query BEFORE you run the crosstab.

Post your table structures and the SQL statement.
 
J

John Spencer

In addition to what Steve Clark has said.

You are going to have to limit the number of the tests you are returning.
Access can handle a MAXIMUM of 255 columns in any query. And _normally_
returns only one value to the "cell".
 
Top