Re: Strange Count problem in Report Group

From: Marshall Barton (marshbarton_at_wowway.com)
Date: 07/18/04 

Date: Sun, 18 Jul 2004 10:22:27 -0500

Barring some kind of corruption, I've never seen that kind
of problem. Just for kicks, try renaming the report, then
Copy/Paste it back to the original name and see what happens
with the new copy.

Depending on how you're applying criteria to the report's
record source, you might be able to use another query to
calculate the number of schoolIDs:

SELECT DISTINCT SchoolID
FROM reportquery

And the report footer text box can then display the count
with:
        =DCount("*", "otherquery")
but this is clumsy at best and it's unlikely that your
report's criteria is that simple.

If anyone else has a clue what might cause this anomaly, I'd
sure like to hear it. 

-- 
Marsh
MVP [MS Access]
Noel wrote:
>Hi Marsh. Yes its definitely in the SchoolID Header 
>section. Bear in mind it shows a count of 1 for every 
>other occasion where I call up one School for the report - 
>at least all of those Ive checked. It seems its just this 
>one School, for some reason. I was thinking, is there any 
>other way to count the SchoolID Header records that I 
>could try, just to compare? Thanks for the reply, Noel
>
>>-----Original Message-----
>>Noel wrote:
>>
>>>Hi. Im having a strange problem with a counting method 
>in 
>>>a report.  My report has three grouping levels, the 
>first 
>>>being by SchoolID. I have set up an unbound txt box, 
>>>positioned in this group, with control source =1, 
>Running 
>>>Sum set to overall and Visible set to No. Then another 
>txt 
>>>box is related to this  in the report footer and shows 
>the 
>>>count of all Schools shown in the report.  I thought 
>this 
>>>was working OK until I filtered down to just one school 
>>>recently (I can do this using a reports selection 
>process 
>>>given to me via this news group with much help from Tom 
>>>Wickerath). For this one school only (perhaps others 
>too – 
>>>I havent checked them all individually) the count shows 
>2. 
>>>As I say most, if not all, others correctly show a 
>figure 
>>>of 1. This seems completely bonkers. If I am grouping by 
>>>SchoolID and that ID is an autonumber field in the 
>School 
>>>table, then how can the count be other than one, if only 
>>>one school is selected and shown on the report? 
>>>
>>>To make things odder, I tried messing about with the 
>other 
>>>records which the report draws on. Each School has a 
>>>number of Mentors and each Mentor has a number of 
>>>meetings. So the three groupings are SchoolID, then 
>>>MentorID, then MeetingID, all autonumber fields. For 
>this 
>>>particular School, I can get it to show a count of 1 if 
>I 
>>>remove one of the Mentors from this school.  I tried to 
>>>find out if it was just one Mentor causing the count to 
>go 
>>>to 2 but at this point I gave up on this theory  
>because, 
>>>even if I could see a pattern, there doesn’t seem any 
>>>reason why my changing the Mentor allocation should vary 
>>>the school count. Other schools have more mentors, with 
>a 
>>>varied pattern of Meetings and they show a correct count 
>>>of 1. 
>>
>>
>>Is the running sum text box in the school head/footer or 
>is
>>in the some other section.  (It sounds like you have it
>>somewhere in the mentor group.)

Relevant Pages

  • Tackling the dropout problem
    ... Unesco's 2007 report highlights Malaysia's efforts to reduce the dropout rate. ... primary school education, writes HARIATI AZIZAN. ... primary school enrolment in the rest of the world has grown by leaps ...
    (soc.culture.malaysia)
  • Re: Hun Sen also singled out higher education institutions as deficient, calling masters and doctora
    ... Report faults school quality ... IN a wide-ranging assessment of the Kingdom's education system, ... At the primary school level, the net enrolment ratio increased by 1.2 ...
    (soc.culture.cambodia)
  • Family Tree Connection Update for 18 Nov 2007
    ... Passaic Dept. of Education 1910-11 Report ... Year Book of the Quaker Club, Tuscaloosa, Alabama, 1904 - 1905. ... The Cobbonian, Annual Publication of the Morristown High School, Morristown, New Jersey. ... King School 1912-1913 Souvenir ...
    (soc.genealogy.marketplace)
  • Re: OT: Has anyone received this va email?
    ... that the email & the news stories appear to be based ... the report is only available as a PDF file. ... schools and *some* teachers were avoiding/dropping the subject. ... This happened with several large city school ...
    (alt.support.mult-sclerosis)
  • Family Tree Connection Update for 13 Apr 2008
    ... Ithaca High School 1931 Commencement ... Pennsylvania Institution for the Blind 1841 Report ... Eighth Annual Report of the Managers of the Pennsylvania Institution for the Instruction of the Blind, Presented to the Corporators, At their Annual Meeting, March 1, 1841. ...
    (soc.genealogy.marketplace)