Passing a Query to a Parameterized Crosstab Query

[PEJO]

I have a crosstab Query that looks like this.

PARAMETERS Course_number Text ( 255 );
TRANSFORM First(NEW_query_serial_credit_info.Score) AS FirstOfScore
SELECT NEW_query_serial_credit_info.userUniqueiD,
First(NEW_query_serial_credit_info.Score) AS [Total Of Score]
FROM NEW_query_serial_credit_info
WHERE (((NEW_query_serial_credit_info.Iteration_Name)=[course_number]))
GROUP BY NEW_query_serial_credit_info.userUniqueiD
PIVOT NEW_query_serial_credit_info.eo_abbrev;


Why can't I query the crosstab query like so:

SELECT * FROM NEW_query_serial_credit_info_Crosstab WHERE 'Course_Number' =
'10'

?

I still get the message box with prompt to enter Course_Number even though
I've specified it in the query.



--

 

[Duane Hookom]

Do you have a field named Course_number?
Try:
PARAMETERS [Enter Course Number] Text ( 255 );
TRANSFORM First(NEW_query_serial_credit_info.Score) AS FirstOfScore
SELECT NEW_query_serial_credit_info.userUniqueiD,
First(NEW_query_serial_credit_info.Score) AS [Total Of Score]
FROM NEW_query_serial_credit_info
WHERE NEW_query_serial_credit_info.Iteration_Name=[Enter Course Number]
GROUP BY NEW_query_serial_credit_info.userUniqueiD
PIVOT NEW_query_serial_credit_info.eo_abbrev;