How to use parameters in a query which is using parametrized query as a source

[accessLearn]

I have an access query Qry1 that needs to run quarterly.


The begin and end dates are hardcoded. Another crosstab query is using Qry1 as a source.
When I try to change the dates as parameters using [BeginDate] and [End Date] for dates, It works in QryA but I encounter the error as “Microsoft Jet database does not recognize [BeginDate] as a valid field name or expression.

How can I fix that?

Thank you,
Blyzz

[pbaldy]

Crosstab Query with a Parameter

[June7]

Paul, that link seems to just go to MS Support search page.

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

[pbaldy]

Hmm, looks like they've taken it down. I've deleted the shortcut so I don't post it anymore.