If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Can 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? |
#2
|
|||
|
|||
Can you count a header field within a report???
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? -- Duane Hookom MS Access MVP -- "jermmcd" wrote in message ... 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? |
#3
|
|||
|
|||
Can you count a header field within a report???
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..... "Duane Hookom" wrote: 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? -- Duane Hookom MS Access MVP -- "jermmcd" wrote in message ... 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? |
#4
|
|||
|
|||
Can you count a header field within a report???
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 -- Duane Hookom MS Access MVP -- "jermmcd" wrote in message ... 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..... "Duane Hookom" wrote: 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? -- Duane Hookom MS Access MVP -- "jermmcd" wrote in message ... 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? |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
sorting data in a report | David | Setting Up & Running Reports | 21 | October 14th, 2005 03:05 PM |
No current record 3021 | hughess7 | General Discussion | 30 | August 19th, 2005 04:39 PM |
Access report - header counting | Dan J | Setting Up & Running Reports | 0 | March 30th, 2005 05:12 PM |
Total hours from Table into Report | HeatherLou1974 | General Discussion | 3 | March 7th, 2005 09:04 PM |
Populate report header field from query parameter | jh | Setting Up & Running Reports | 7 | November 13th, 2004 07:38 AM |