query based on query

[mperrone]

I'd like to run a

 query, then run a second query against the results of the first and use that second qury as the basis for my report.  I suspect I may be able to do this using either a temporary table or a subreport, but my proficiency level is quite low and I haven't had much luck sorting through & finding clues within this forum.  Can anyone help me?

Thanks,

Mike Perrone

[iancr01]

You may want to create an input control for your report and make it of type Single-Select Query or Multi-Select Query. That report will take as parameters the results of the query in the input control.

[mperrone]

I ended up figuring out how to create a subreport and that took care of it.  Thanks though...