Queries flaking out

W

Ward

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.
 
D

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)?
 
W

Ward

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
 
Top