Is this possible?

[Guest]

I have created several reports that has a total in the header of each report.
What I would like to do, if possible, create a new report consisting of only
the header information from each report.

Each report header has the PO #, Projected Total, Leasestartdate,
Leaseenddate, and today's date.

If I can't take the info from the header from each Report is there another
way to get the Projected Total for each PO so that I can create a Report with
the info I have above.

Thanks for any help!

 

[Guest]

Try using a Totals query.

 

[Guest]

How would I do a Totals query if the Total is in the header of the report?
When setting up the query there is no option to chose this field.

 

[Guest]

Query the same table records that contain the data used in the report.