Message for Marshall Barton

[Noel]

Hi again Marsh. You remember you were helping me with an
earlier post re a Strange Count Problem in a Report? I
posted this on the other thread earlier today - reposted
here also to hopefully catch your eye.

Well, your suggestions didnt bear fruit Im afraid but
something I just tried may throw some light on things,
although it seems just as improbable. For some reason I
decided to set Visible = True in the txtCountofSchools
text box which is in the SchoolID Header area and now,
when I specify that same odd School name,
txtCountofSchools correctly shows 1 and the text box in
the report footer, whose Control Source is set to =
[txtCountofSchools] shows 2. I changed the name of
txtCountofSchools and the Control Source of the footer
text box to make sure I hadnt got some hidden text box
somewhere and this confirmed that theyre linked OK. I
then set up a completely new text box in the SchoolID
header, called it txtCount, set control source to =1 and
Running sum = Over All and added a second txt box in the
footer set to control source =[txtCount]. Same result. I
then moved one of the footer text boxes into the SchoolID
area and it correctly shows 1. But if I move it back to
either the report or page footer, it shows 2. Am I going
mad? - surely if the footer text boxes control source is
the txt box in the Header, it has to show the same value,
no matter where its postioned. Any further ideas??? By
the way, Ive proved that the count is accurate in many,
if not all, other instances - even when I specify a
criteria for the report that allows this particular
school to be included (e.g by specifying a particular
Type of School or County). I would be interested in any
further views or tests you might have. Perhaps I need an
exorcist. Cheers, Noel

 

[Marshall Barton]

Hi again Marsh. You remember you were helping me with an
earlier post re a Strange Count Problem in a Report? I
posted this on the other thread earlier today - reposted
here also to hopefully catch your eye.

Well, your suggestions didnt bear fruit Im afraid but
something I just tried may throw some light on things,
although it seems just as improbable. For some reason I
decided to set Visible = True in the txtCountofSchools
text box which is in the SchoolID Header area and now,
when I specify that same odd School name,
txtCountofSchools correctly shows 1 and the text box in
the report footer, whose Control Source is set to =
[txtCountofSchools] shows 2. I changed the name of
txtCountofSchools and the Control Source of the footer
text box to make sure I hadnt got some hidden text box
somewhere and this confirmed that theyre linked OK. I
then set up a completely new text box in the SchoolID
header, called it txtCount, set control source to =1 and
Running sum = Over All and added a second txt box in the
footer set to control source =[txtCount]. Same result. I
then moved one of the footer text boxes into the SchoolID
area and it correctly shows 1. But if I move it back to
either the report or page footer, it shows 2. Am I going
mad? - surely if the footer text boxes control source is
the txt box in the Header, it has to show the same value,
no matter where its postioned. Any further ideas??? By
the way, Ive proved that the count is accurate in many,
if not all, other instances - even when I specify a
criteria for the report that allows this particular
school to be included (e.g by specifying a particular
Type of School or County). I would be interested in any
further views or tests you might have. Perhaps I need an
exorcist. Cheers, Noel

An exorcist may provide more useful results than I can come
up with here ;-\

I have never seen and can not imagine a situation that
causes what I think you're describing. I'm just plain out
of ideas here ;-(

If you want to grasp at a pretty thin straw, try blaming it
on some kind of corruption. See Tony's FAQ at:

http://www.granite.ab.ca/access/corruptmdbs.htm

 

[Noel]

Thanks for this Marsh. Ill have a look at the link youve
suggested and if I dont have any success, Ill have to
give up and take the Count facility off this report.
Thanks again for the help, Noel

-----Original Message-----

Hi again Marsh. You remember you were helping me with an
earlier post re a Strange Count Problem in a Report? I
posted this on the other thread earlier today - reposted
here also to hopefully catch your eye.

Well, your suggestions didnt bear fruit Im afraid but
something I just tried may throw some light on things,
although it seems just as improbable. For some reason I
decided to set Visible = True in the txtCountofSchools
text box which is in the SchoolID Header area and now,
when I specify that same odd School name,
txtCountofSchools correctly shows 1 and the text box in
the report footer, whose Control Source is set to =
[txtCountofSchools] shows 2. I changed the name of
txtCountofSchools and the Control Source of the footer
text box to make sure I hadnt got some hidden text box
somewhere and this confirmed that theyre linked OK. I
then set up a completely new text box in the SchoolID
header, called it txtCount, set control source to =1 and
Running sum = Over All and added a second txt box in the
footer set to control source =[txtCount]. Same result. I
then moved one of the footer text boxes into the SchoolID
area and it correctly shows 1. But if I move it back to
either the report or page footer, it shows 2. Am I going
mad? - surely if the footer text boxes control source is
the txt box in the Header, it has to show the same value,
no matter where its postioned. Any further ideas??? By
the way, Ive proved that the count is accurate in many,
if not all, other instances - even when I specify a
criteria for the report that allows this particular
school to be included (e.g by specifying a particular
Type of School or County). I would be interested in any
further views or tests you might have. Perhaps I need an
exorcist. Cheers, Noel

An exorcist may provide more useful results than I can come
up with here ;-\

I have never seen and can not imagine a situation that
causes what I think you're describing. I'm just plain out
of ideas here ;-(

If you want to grasp at a pretty thin straw, try blaming it
on some kind of corruption. See Tony's FAQ at:

http://www.granite.ab.ca/access/corruptmdbs.htm