Query a result?

[Paul]

Is it possible to query a result set? ____Or to create sub-querys?____If so, how?________Thank you,____Paul

[kfleming]

You could add additional conditions to the current query to further refine the result set.____Kathleen__R&R Support

[Tom_Cangemi]

Though refining a query is always the best way to get results - sometimes I have found it isn^t possible to get results you want in a single pass -perhaps this is the reason for Paul^s question.____In some instances you must query the result set by Exporting it out to a *.dbf file and then querying and/or joining or adding a join to that resulting exported file in a second query. ____It would be nice if a 2 pass query were possible in one step - or perhaps it is and I haven^t run across it yet - I thought dynamic parameters might give it to us - but that doesn^t seem to exactly give us a two pass query either.