Placing a report group subcount in report header.

  • Thread starter Thread starter Frank
  • Start date Start date
F

Frank

I have a report in access 2002 based on a query.

In the report, I have a group within the report that is set up to subcount
orders by first letter - e.g.. subcount all order begging with A and B. -
i.e.. text box formular is Count([orders]).

I also have a grandtotal at the end of the report nestled in the Report
Footer.

I would like to create two subcount text boxes and place them in the report
header. These boxes would represent the subcount total of all A orders and
all B orders. If this can be done, the reader can see a total count of all
A and a total count of all B without having to scroll through the entire
report. Additionally, I would create a new text box for the Grand Total of
all orders as well.

What is best way to do this? Any assistance is greatly appreciated.
 
I have worked out some thing with some queries.
If you would like for me to send you this in a sample MDB
let me know.
If you wish you may contact me at my email.
Fons Ponsioen
 
Back
Top