If you can't use a sub-report, then (since a report can only have a single
recordsource) you have two choices:

1.  Combine both your queries into a single query which you use as the
recordsource for your report, and put the appropriate data fields into the
detail and report footer sections.

2.  Use dlookup statements in the report footer to get the data from the
second query (this is only likely to be a usable option if the second query
returns a limited dataset).

HTH,

Rob