By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
435,057 Members | 1,249 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 435,057 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

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

Jun 30 '17 #2

Expert Mod 15k+
P: 31,494
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
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.