CrossTab/Form Query Problem.

[dbero]

I am attempting to create a crosstab query for a chart. In one of the subqueries, I limit the values by pulling in a value from a combobox setting the criteria to '[Forms]![Form1]![Combo5].[Value].

However, by doing so I get the error message "the Jet Database engine does not recognize 'Forms!Form1!Combo5.value' as a valid field name or expression". The base query works fine with this logic, but the crosstab only works if I remove this criteria.

I have tried adding the parameter values to the subqueries, to no avail. Anybody have any suggestions on how to get the cross tab to work?

Thank you Very Much!

 

[SoCalAccessPro]

Specify the column headings or declare the parameter. Both of these tasks can be performed in query design view and right clicking to view the queiries properties.

Tyrone Lumley
SoCalAccessPro

http://www.socalaccesspro.com

 

[dbero]

I added the parameters using
PARAMETERS REGIONAL Text ( 255 ); i added this to the SQL in both subqueries. This field is not used at all by the crosstab and i couldn't add it there.

Is this what you are referring to?

 

[SoCalAccessPro]

Yeah, that should do it. Did it stop the prompt from displaying ?

Tyrone Lumley
SoCalAccessPro

http://www.socalaccesspro.com

 

[dhookom]

Your parameter is
Forms!Form1!Combo5
You must select its data type in your query parameters.

Duane
Hook'D on Access
MS Access MVP