using multiple queries to generate a report.

[nickwooly]

Is there a way in CR 8.5 to query the results from one query to generate a report. Here's my problem: I have an assignments table that contains a user, their assignment begin and end dates (among other irrevelvant data). The end result (my objective) needs to be a list of users that had their first assignment date in a certain month. I can run a query and group the results by user name and assignment begin date. That gives me each users first assignment. Then if I run another query upon those results I can get the list I need. My problem is how can I combine these 2 queries in CR 8.5?? Or how can I run the first one, then query those results with the second?? Any help would be appreciated!