Queries flaking out

Is there a limitation on the complexity of queries used in a report? I have
created queries that are based on other queries that return values for
calulated fields, but the values will not display in report text boxes.

Do the queries run by themselves (i.e.: can you run the query by
double-clicking on it on the Queries tab)?

--
Doug Steele, Microsoft Access MVP
http://I.Am/DougSteele
(no e-mails, please!)



"Ward" wrote in message
news
Is there a limitation on the complexity of queries used in a report? I
have
created queries that are based on other queries that return values for
calulated fields, but the values will not display in report text boxes.

Thanks for your response Douglas. I've been away for a while, so just got
your response.

The queries run just fine when double-clicked, although dialog boxes pop up
asking for parameters that will be supplied by the parent query(s). I just
click throught the dialogs without rsponding with values. The result set
contains all of the appropriate values. It is only when I run a report based
on the query that the values fail to be generated. Hope this makes it clearer.

Thanks

"Douglas J. Steele" wrote:

Do the queries run by themselves (i.e.: can you run the query by
double-clicking on it on the Queries tab)?

--
Doug Steele, Microsoft Access MVP
http://I.Am/DougSteele
(no e-mails, please!)



"Ward" wrote in message
news
Is there a limitation on the complexity of queries used in a report? I
have
created queries that are based on other queries that return values for
calulated fields, but the values will not display in report text boxes.