Filtering Crosstab Queries

[McArthurGDM]

I have a crosstab query.



There is a field for row headings that specifies QUARTER (Q1,Q2, Q3,Q4) and another field for row headings that specifies YEAR(2015,2016,...etc)

I want to be able to have the user input the criteria in to a box and filter the crosstab query to then display the filtered results.

Right now on my column headings I have MONTH.

When I try to reference the form in the criteria, I always get the error

"The Microsoft Database Engine does not recognize ..... as a valid field name or expression"

Does this mean that you can not filter crosstab queries?

​Thanks,

[pbaldy]

See if this helps:

Crosstab Query with a Parameter

[McArthurGDM]

This is getting me on the right track... but I need an example. This article doesn't give one. I haven't the slightest indication of what to put into the Query Parameters box and/or the Criteria section of the query itself.

Usually, I reference the unbounded form within the criteria section - this doesn't work. So what is it that I have to put in the Query Parameters box?

This article does not illustrate that.

[June7]

Here is another reference http://allenbrowne.com/ser-67.html#Param

[McArthurGDM]

Okay. I see what it means to reference a control on a form within the Parameters box.

How does the Query itself actually know what to filter, though?

For instance,

If I type [Forms].[Forms1].[StartDate] of datatype Date/Time into the Parameters box.

The query itself has no idea where to place that actual criteria, no? What do I put within the criteria section next within the query?

[June7]

I think you build the WHERE clause as normal with reference to the form control. (I don't have need for CROSSTAB queries, so try it and let me know.)