Let me start off by stating that I use Access, but have limited knowledge in SQL... I do have a good understanding of programming (C++) though, so I can follow the logic behind it. But I use dirty but quick methods of doing things in Access that work but probably isn't the best or simiplist methods because I don't know how to do them.

Okay, the problem is that I use a lot of reports in Access that runs off of a query (Query2) that runs off of a query (Query1) that asks for parameters. When I run Query2, it only asks for the parameters from Query1 once. However, when I run the report, I get repeated prompts to enter the parameters-- often 3 or 4 times. Also, it takes a long time to run compared to other reports that use the same data set or ones that don't ask for parameters. The reports work, but it's just annoying and time consuming to keep entering the parameters. It's not just one report, but multiple ones in different databases that do this and use the same method. The reports calculate sums and counts.

Does anyone know what is causing the repeated prompts?
Or what additional information do you need to know?

I may be able to help you.. I had a similar problem with a few of my queries when I first started out with SQL, but I'd have to see the code you've written to be able to offer any sort of direction. Could you post the code so we could have a look at it?

The repeated prompts don't occur when I just run the queries though. It only happens when I run the reports that use the queries.
I don't know how to post the code from the report... but here is the queries that run the report... although like I said, the problem only happens when I run the report and not just the queries.