Report with subreport at bottom only

I have a query that lists information from work orders showing the time between when a work order was written and when it was completed. I also have a query that figures out the average time for all these work orders. I want to make a report where it lists all the info from the first query, then at the end shows the info from the second query which displays the average of all the above info.

However, when I try to build this, all I get is a report with the average insterted after each record instead of after all records.

Any ideas?

Use a subreport in your main report's Report Footer section.

--
Duane Hookom
MS Access MVP


"dvgrhl" wrote in message
...

I have a query that lists information from work orders showing the time
between when a work order was written and when it was completed. I
also have a query that figures out the average time for all these work
orders. I want to make a report where it lists all the info from the
first query, then at the end shows the info from the second query which
displays the average of all the above info.

However, when I try to build this, all I get is a report with the
average insterted after each record instead of after all records.

Any ideas?


--
dvgrhl