Not recognizing as a valid expression? 1

[Aximboy]

I have a query that filters the years based on a form input.

Here is how the filter looks like:
WHERE (((Format([Request Date],"yyyy"))=[Forms]![frmStatus]![txtStatusYear]));

When I click Run...
The query runs fine.
The union query runs fine.
However, the crosstab query gives me an error.

It says "The Microsoft Office Access database engine does not recognize '[Forms]![frmStatus]![txtStatusYear]' as a valid field name or expression.

Any suggestion on this?

 

[dhookom]

You must declare the data type of parameters used in crosstab queries. Find Parameters in the query properties dialog. I would set the type to integer and change the where clause to:

WHERE Year([Request Date])=[Forms]![frmStatus]![txtStatusYear];

Duane
Hook'D on Access
MS Access MVP

 

[Aximboy]

It works!!!
But it took me awhile to figure out how to use the Parameters properties dialog.
Again, thank you so much!!!