Counting records in a report

  • Thread starter Thread starter Griff
  • Start date Start date
G

Griff

Hi,

If for example I have created a Grouped report with say just 2 Field Names
NAMES & HOURS.
I have 6 Names and 10 entries against Hours for each Name.
I seem to be able to find out how to count the Hours entries against each
Name that is =COUNT([HOURS]) the report shows 60 which is correct.
But if I try =COUNT([NAMES]) I still get 60 not 6 - incorrect.
Where am I going wrong please?
Regards,

Lynda.
 
Lynda,

Try it like this...
In the NAMES Footer section of the report, put an unbound textbox, and
set its Control Source property to =1, and its Running Sum property to
Over All. Let's say you call this control NamesCount. Ok, now in the
Report Footer, put another unbound textbox, with its Control Source
property set to =[NamesCount]
 
Try it like this...
In the NAMES Footer section of the report, put an unbound textbox, and
set its Control Source property to =1, and its Running Sum property to
Over All. Let's say you call this control NamesCount. Ok, now in the
Report Footer, put another unbound textbox, with its Control Source
property set to =[NamesCount]
Click to expand...

Thanks for that Steve,

I have tried that with some success but it produces a Name Count after each
Name.
I would like to acheive a total of the Names in the Report Footer rather
than the Names Footer, how is this possible?

Thankyou,

Lynda.
 
Lynda,

What I described to you in my earlier response was designed to do
exacltly that. I should have also said to set the Visible property to
No for the NamesCount control in the NAMES Footer.
 
What I described to you in my earlier response was designed to do
exacltly that. I should have also said to set the Visible property to
No for the NamesCount control in the NAMES Footer.
Click to expand...

Thanks again Steve,

Now the count has gone from each Name Group but still a count does not
appear in my Report Footer which is where I want it.

Lynda.
 
Lynda,

To reiterate from my earlier response, did you do what I suggested?
Did you name the control in the NAMES Footer section NamesCount? And
then, in the Report Footer, did you put another unbound textbox, with
its Control Source property set to =[NamesCount]? If so, what is
appearing in this textbox in the Report Footer? You're not really
giving me enough information so far to know what is not working properly.
 
Steve,
Did you name the control in the NAMES Footer section NamesCount?
Click to expand...
Yes. Control Source shows NamesCount
then, in the Report Footer, did you put another unbound textbox, with
its Control Source property set to =[NamesCount]?
Click to expand...
Yes and in Properties, Control Source shows =[NamesCount]
If so, what is appearing in this textbox in the Report Footer?
Click to expand...
When I return to Preview, I get a box asking 'Enter Parameter Value'
'NamesCount' to which I do OK (not suer what to enter) and then in the
Report Footer against Names Count there is nothing?

Must be me.

Thanks for trying.

Lynda.
 
Back
Top