Parameter Query Prompts Twice

[Garridon]

I've been working on a report and a subreport that has some calculations in it. Subreport displays the records and calculates the total number. Main report takes that total, counts the overdue records and divides it to get a percentage.

My user wanted to be able to pick a date criteria, so I inserted Between [Beginning Date] and [Ending Date] into the query for the subreport, where all the records are displayed. When I open the report, it prompts me twice for the set of dates. What is causing this?

Thanks!
Linda Adams
Visit my web site for writing and Microsoft Word tips:

http://www.hackman-adams.com

http://www.david-hedison.com

 

[jebry]

Hi Linda!

It sounds like your report and your subreport are based on the same query. What is the recordsource for each?
Jeff Bridgham
bridgham@purdue.edu

 

[Garridon]

They're actually two different queries--I had to do a subreport because I needed it to count the total number of records and the total overdue to get the percentage. Both queries have a common field--dateClosed. The main report counts records that are overdue based on dateClosed and dateDue. The subreport counts the total number of records based on dateClosed.

Linda Adams
Visit my web site for writing and Microsoft Word tips:

http://www.hackman-adams.com

http://www.david-hedison.com

 

[jebry]

Hi Linda!

Sorry to take so long answering. Maybe you could send me the database(zipped) or a blank database with the report, queries and tables involved. If you can do that, I'll take a look at it to see if I can figure out what is happening.

hth Jeff Bridgham
bridgham@purdue.edu

 

[BMeek]

I have run into times where a parameter is prompted more than once as well. My cases were caused by a sort after the query ran once. Then when Access sorts the data, it actually runs the query again and therefore prompts the user again. Are you sorting the results before displaying the report?

The way I got around it was using a form with a dropbox to hold the value the user wants as a parameter. Then pointed the query to look at the dropbox on the form when running the query. It still runs twice, but the user isn't prompted over and over for the parameter.
Bryan Meek
bmeek@pacbell.net

http://www.handtech.com/meekent

A "Solution Provider" in your corner gives you the personal attention you need to find the right technology solutions for your business.