By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,480 Members | 2,766 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,480 IT Pros & Developers. It's quick & easy.

Crosstab query prompts twice for parameters

P: 1
My crosstab query calls a union query that prompts for the start data and end date and another criteria.
Sometimes, but not always, the crosstab query prompts *twice* for these parameters.
Is there a fix for this?
Jun 30 '17 #1
Share this Question
Share on Google+
3 Replies


PhilOfWalton
Expert 100+
P: 1,430
Thank you for letting us know

Phil
Jun 30 '17 #2

NeoPa
Expert Mod 15k+
P: 31,186
I've never experienced such behaviour within a single query. Are you sure this is just the query being run once? Not code invoking anything you're unaware of?
Jul 1 '17 #3

Narender Sagar
100+
P: 189
It happens when, after running a query, if you do some 'sorting' of data, access will ask for Parameters two times, every time you re-run it. (Remember, I'm not talking about sorting in design view of the query).
Fix of this is, just carry out sorting in design view and save your query. It will not ask for the parameters twice.
Jul 4 '17 #4

Post your reply

Sign in to post your reply or Sign up for a free account.