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

Access Report Issue

P: 13
I have an access Report A generated by Query A, I copied Query A as Query B and replaced some columns by adding new columns. So when ever I run
Report A now referred to Query B I am getting the pop windows "Enter Parameter Value" to enter the value for the columns I deleted. I have to click OK…. To get rid of it then the report is displayed.
Can anyone please let me know how to get rid of Parameter Value window.

Thanks
Mar 26 '07 #1
Share this Question
Share on Google+
6 Replies


Rabbit
Expert Mod 10K+
P: 12,335
Go to query B and get rid of anything that refers to the columns you deleted.
You also have to do the same for report A.

If you need report A for query A and report A for query B then you'll have to create a report B.
Mar 26 '07 #2

P: 13
ssq
Thanks Rabbit, sorry i forgot to mention that i already did what you said but still the same error ?
Mar 27 '07 #3

Denburt
Expert 100+
P: 1,356
I copied Query A as Query B and replaced some columns by adding new columns.
Now create a NEW report for query B if you copy Report A to create a report B then you will have this problem. You will want to open query B and make sure the prompts are not comming from there since the sort order of an MS Access query can be stored in the properties page, and might be overlooked. Hope this helps.
Mar 27 '07 #4

P: 13
ssq
Thanks, i am trying to do that, i should i add "Master Index Header" that was in the previous report.

Thanks once again for the quick response.
Mar 27 '07 #5

P: 13
ssq
I mean i have to had "Master Index Header and Footer" which was existing in the previous report, how can i insert "Master Index Header and Footer" ?
Mar 27 '07 #6

Denburt
Expert 100+
P: 1,356
Use that as the Main report put a sub report on there, once you do that you can change the source to report A or Report B.
Mar 27 '07 #7

Post your reply

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