It it possible to make parameters in a CrossTab query?

[accessmatt]

Hello,

It it possible to make parameters in a CrossTab query (i.e. between two dates)?

Thanks

[ranman256]

Yes, but 2 things...
1. Its better to put the params in the query before it...the query to make into a Xtab query .

2. you MUST put the params in the Xtab query too but ..NOT in the query design grid, but rather , from the menu, query, parameters.
Even tho theyre not in the query itself...it will want to know them anyway.

"It WANTS to be found."

[accessmatt]

Ranman256,

I did both of those things and somethings not right because after I enter the Parameters, it asks me to enter them again until I cancel it out. Would you mind taking a look:

https://drive.google.com/file/d/0B0DOuRuNEQsOeXZ6SkJpY1pINVE/view?usp=sharing

thanks,

[June7]

Review http://allenbrowne.com/ser-67.html