Crosstab query not recognize input date text box (1 Viewer)

[Sokkheng]

I have create Crosstab query that source is get from the first query that have input Start Date and End Date get from my input form. when i run the crosstab query it show message : The Microsoft database engine does not recognize '[Forms]![frmNavigationForm].[Form]![txtStartDate]' as a valid filed name or expression.
But for the other select query is ok, it does't running only crosstab query.
What is my mistake in crosstab query?
Thanks for help

 

[jdraw]

Check the links in the Similar Threads at the bottom of the page.

 

[theDBguy]

You probably have to declare the parameter in your crosstab query (at least, if not in both).

 

[ebs17]

Form references in queries are always a bit problematic because Jet itself does not recognize objects such as Access forms. In some cases, Access resolves the content of a form control when passing the query to Jet, and Jet can do something with the substituted value.
However, in some cases (crosstab queries, parameters in subqueries, passing the query to DAO) this does not work. However, these internal reprocessings are not consistently implemented, the developer then has to get by and act without "Pampers".

There are several ways to pass parameters to queries. In a simple case, try using Eval in the query:

Forms.frmNavigationForm.Form.txtStartDate
=>
Eval("Forms.frmNavigationForm.Form.txtStartDate")

In the expression I removed the stupid superfluous brackets. Brackets used should have a meaning, which is not the case here.

Like I said, if that's not enough, there are other options.

 

[Pat Hartman]

Setting the parameter in the crosstab should solve the problem but always remember when using dates from unbound controls as parameters to set the format of the control to a date format so that the expression engine recognizes that you intend for the data to be a date.