How to Add User Input Criterion to an Access Inner Joined Crosstab Query

Question

Prompting for user input parameters in an Access query is fairly straight forward. Go to design view and under criteria, just put [Your Text:] -- and when the query runs the user is prompted for the field criteria.

Unfortunately when I try this with my Inner Joined Crosstab query I get the error:

The Microsoft Access engine does not recognize the '[Your Text:]' as a valid field name or expression.

I know the inner join crosstab still allows for criteria, as hardcorded criterion works.

To give you a better idea of what I'm looking at, here is the SQL code.

DOESN'T WORK:

SELECT *
FROM ([CrossTabQ1] 
INNER JOIN [CrossTabQ2] ON [CrossTabQ1].[Month] = [CrossTabQ2].[Month]) 
INNER JOIN [Query3] ON [CrossTabQ1].[Month] = [Query3].[Month]
WHERE ((([CrossTabQ1].[Month])= [Enter Month, in YYYY-MM Format:]))
ORDER BY [CrossTabQ1].[Month];

DOES WORK:

WHERE ((([CrossTabQ1].[Month])="2015-12"))
ORDER BY [CrossTabQ1].[Month];

Any tips regarding why I'm getting this error and how I can accept user input criterion would be greatly appreciated!

Answer 1

Try:

PARAMETERS Enter_Month Text ( 255 );
SELECT *
FROM ([CrossTabQ1] 
INNER JOIN [CrossTabQ2] ON [CrossTabQ1].[Month] = [CrossTabQ2].[Month]) 
INNER JOIN [Query3] ON [CrossTabQ1].[Month] = [Query3].[Month]
WHERE ((([CrossTabQ1].[Month])=[Enter_Month]))
ORDER BY [CrossTabQ1].[Month];