Crosstab Criteria (1 Viewer)

[Brian Robertson]

I've set up a Crosstab query with one Row one Heading and One
Value field. I've added another field against which I want to add a criteria that looks at the value in a Combo box on a form, which is active. As suggested in Help for this field I have the Total section set to "Where" and nothing in the "Crosstab" section. I'm getting an error that "Jet" does not recognise the criteria. I've tested the criteria to ensure it works in normal "Select" queries and it does. Where am I going wrong !!!!

 

[Rich]

You have to define the Parameters Forms!MyFormName!MyCombo.BoundColumn/Text etc

 

[Brian Robertson]

Thanks rich -


According to the Properties for the Combo, all the parameters are set. Or am I missing the point ?

 

[Rich]

It's the crosstab query that requires the parameters