 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
MS Access Forum / Reports / Printing / December 2005Can you count a header field within a report???
I have a report and I want to count the # of times a specific header titled "WW Header" appears within a report. How can I do that? Without more information, I can only suggest you print, count, write down the count. Reports have Page, Group, and Report Headers. Which one are you referring to? Can you provide some sample records and layout so we can picture your issue?  SignatureDuane Hookom MS Access MVP -- >I have a report and I want to count the # of times a specific header titled > "WW Header" appears within a report. How can I do that? Duane, On my report a have a field ("WW") set up as a header. This field is populated from a query, so it changes weekly. I don't want to take a count from any field in the "Detail" section of the report due to many occurrences of activities falling within any given WW. I only want to be able to count within the report how many "WW"'s are represented on the report. It is set up like this: "WW Header" WW "Details" Text box(count) Date of Activity Activity Within the details section, the count isn't important to me as I have numbered each activity within the WW group. But one week I might have only 1 WW, and the next I might have 20 WW's, so I want to there to be a Text box that allows for this # to be displayed. Hope this clarifies..... > Without more information, I can only suggest you print, count, write down > the count. [quoted text clipped - 4 lines] > >I have a report and I want to count the # of times a specific header titled > > "WW Header" appears within a report. How can I do that? WW is a Group Header. Apparently you want to count the number of group headers in your report. Create a text box in the group header: Name: txtCountWW Control Source: =1 Running Sum: Over All Visible: No Add a text box to your report footer: Control Source: =txtCountWW SignatureDuane Hookom MS Access MVP -- > Duane, > [quoted text clipped - 29 lines] >> >titled >> > "WW Header" appears within a report. How can I do that? |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.