Regarding my previous post...
http://www.access-programmers.co.uk/forums/showthread.php?s=&threadid=44309
I have managed to get the thing to count by entering a calculated box named RecordCount(ControlSource=1, Running Sum Over All) in the group header that shows a total after the last record. However, the report can be 200 pages long. I would like the sum to appear in the report header. I entered another box in the header referencing the RecordCount field, but it comes up 1. If I put it in the report footer, it comes up correctly, but even if I make the header field reference the footer field, it STILL gives 1. This does not seem like it should be so complicated. Can someone please assist? I'm sure I'm missing something minor. Thanks for your help!
http://www.access-programmers.co.uk/forums/showthread.php?s=&threadid=44309
I have managed to get the thing to count by entering a calculated box named RecordCount(ControlSource=1, Running Sum Over All) in the group header that shows a total after the last record. However, the report can be 200 pages long. I would like the sum to appear in the report header. I entered another box in the header referencing the RecordCount field, but it comes up 1. If I put it in the report footer, it comes up correctly, but even if I make the header field reference the footer field, it STILL gives 1. This does not seem like it should be so complicated. Can someone please assist? I'm sure I'm missing something minor. Thanks for your help!