Counts not counting the field that I'm asking it to

[KelMcc]

In this report, I have it subsort by "BA". In the "BA Footer" (not the page footer), I've put in a count: =Count([DtReceived])

"DtReceived" is a field in the Header. So, basically, for each "BA", I'm trying to count header records. What it is doing, though is counting the detail records, even though "DtReceived" is NOT a name of either field in my detail record.

So, for instance, BA=Jones, and has 2 Header records, so I'd like the count to say "2". Under each header is, say 3 details. The problem is my count is giving me a reply of 6, not 2, even though I've told it to count the header record....

I hope this makes sense.

How can I get this bugger counting correctly?

 

[Elana]

I pulled this from Access help...does it give you what you are looking for?


Count the number of records in each group in a report

1 Open the report in Design view.
2 Add a calculated text box to the detail section.
3 To display the property sheet, make sure the text box is selected, and then click Properties on the toolbar.
4 Set the following properties.

Property Setting
Name RecordCount
ControlSource =1
RunningSum Over Group
Visible No

5 Add a calculated text box to the group footer.
6 To display the property sheet, make sure the text box is selected, and then click Properties on the toolbar.
7 Set the ControlSource property to the name of the control in the detail section that's tracking the running total; for example, =[RecordCount].

 

[KelMcc]

Not really, unless I'm misunderstanding something.... (but I do appreciate the suggestion! )

What you've cited will sum the detail records. My report will have a several headers w/ multiple details. I want to count the headers.

I will try this but at the header level and see if it works. In the mean time any other suggestions would be appreciated.

 

[KelMcc]

*bump*

Can anyone else give me some advice here? Have I come upon an Access limitation?

 

[Rich]

Why do you put the details in the header and not the detail section?

 

[KelMcc]

Sorry I didn't reply sooner, Rich. I got caught up in some of my forms and let this go for a bit. Now, my forms are in pretty good shape and I'm revisiting these report issues.

The report I'm trying to get this sum for has 2 headers and a detail. I made it with the report wizard and I wanted it broken down first by employee name (the primary heading), then by task by employee (2nd header). Within each task I list all the comments that have posted for the task (detail).

I then put a sum command in "Employee name footer" but it will only sum detail level. It won't sum the tasks under each employee... or at least I can't get it to.

So, in this report, I get 2 employees, the first has 5 tasks under him, each task has 10 comments. I want to sum the 5 tasks, not the consequent 50 tasks.

 

[Rich]

Add a task footer and sum there

 

[KelMcc]

I've done that. I've added a footer for Task, for the Employee, even both at the same time. Its like that feature (count) is reserved strictly for detail information.

 

[Rich]

I suspect you need a subreport for comments or both comments and tasks

 

[KelMcc]

*notes "subreport"*
*runs off to investigate*

I'll see what that yields. Tx Rich!

 

[KelMcc]

FYI, Elana, your suggestion, now that I'm 3 months older in my Access education, worked like a CHARM!