A Microsoft Office (Excel, Word) forum. OfficeFrustration

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.

Go Back   Home » OfficeFrustration forum » Microsoft Access » Setting Up & Running Reports
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

Can you count a header field within a report???



 
 
Thread Tools Display Modes
  #1  
Old December 14th, 2005, 02:50 PM posted to microsoft.public.access.reports
external usenet poster
 
Posts: n/a
Default 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  
Old December 14th, 2005, 03:19 PM posted to microsoft.public.access.reports
external usenet poster
 
Posts: n/a
Default 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  
Old December 14th, 2005, 03:52 PM posted to microsoft.public.access.reports
external usenet poster
 
Posts: n/a
Default 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  
Old December 14th, 2005, 05:06 PM posted to microsoft.public.access.reports
external usenet poster
 
Posts: n/a
Default 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

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump

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


All times are GMT +1. The time now is 01:27 AM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 OfficeFrustration.
The comments are property of their posters.