Queries flaking out

[Guest]

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.

 

[Douglas J. Steele]

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

 

[Guest]

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