using a form control in a cross tab query 1

[kkarren]

I have a query that selects a date range from a form. The query itself runs fine, however when I attempt to use the query for the basis of a cross tab query it errors out and give me a message " The Microsoft Jet database engine does not recognize'[forms]![frmwork]![start_date] as a valid field name or expression" Are there any ideas why I am getting errored out when the expression works fine in the regular select query?

 

[danvlas]

If your crosstab query depends on parameters, you have to define such parameters in the base query.
Go to the base query in Design View, click Query->Parameters.
Enter the parameter names : [forms]![frmwork]![start_date] and [forms]![frmwork]![end_date]
and the correct type (probably Date/Time)

Save the base query and run the crosstab. It should work.

Dan

 

[kkarren]

Thanks Dan that worked. You are awesome.