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

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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???
 
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.
 
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".
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

What Kind Of Query Can I use? 6
Problem testing for sinmilar values in two fields? 1
help with outer join 3
Displaying un-matched records in query/crosstab query 2
Display crosstab query result with conditional formatting 2
Need Result show in Message Box 2
CrossTab Combining 2 fields into Column heading 1
How to display multiple IIf results in one column 1

Back
Top