totals

  • Thread starter Thread starter Rhun Alexander via AccessMonster.com
  • Start date Start date
R

Rhun Alexander via AccessMonster.com

Hi I have a problem... it goes as fellows, At the end of each set of
patient records you can create a text box that holds the dummy value of 1
(see on-line help). Of course you do not wish to see this value so you can
use the visible property. This value will form the running sum for the
number of patients – you need to decide which type of running sum.
Essentially, this box is counting the number of patients; it needs to be re-
set after each ward.

I can creat a dummy text box and input =1 into it and I have a lable to
output it but I can't find a way for the lable to count the number of times
the text box appears in the form or to put it another way to total the
number of ones, any help would be welcome, and thanks for your time.
 
Rhun said:
Hi I have a problem... it goes as fellows, At the end of each set of
patient records you can create a text box that holds the dummy value of 1
(see on-line help). Of course you do not wish to see this value so you can
use the visible property. This value will form the running sum for the
number of patients – you need to decide which type of running sum.
Essentially, this box is counting the number of patients; it needs to be re-
set after each ward.

I can creat a dummy text box and input =1 into it and I have a lable to
output it but I can't find a way for the lable to count the number of times
the text box appears in the form or to put it another way to total the
number of ones, any help would be welcome, and thanks for your time.
Click to expand...


The RunningSum text box counts the number times it is
incremented, so all you need to do in the next higher level
footer section is use a text box that refers to the
RunningSum text box.

If you set the RunningSum property to Over All, it will
count through the entire report. If you set it to Over
Group it will automatically reset at the start of the next
higher level group header.
 
Thank you for your input, I must of been far to tired last night when I
tryed to do this and what you dais helped jog my memoery, and now it works
fine, thank again.
 
MMMM another snag I count count the totals fine now but my problem lies in
counting the total of the totals, I use the total to count patients in a
ward, on a shift, and I need totals of totals to be all the patients on
that shift. But to reset for the next shift like totals does every ward, I
tryed a overall calculate text and it worked for the first but then diddn't
reset for the next one
 
Rhun said:
MMMM another snag I count count the totals fine now but my problem lies in
counting the total of the totals, I use the total to count patients in a
ward, on a shift, and I need totals of totals to be all the patients on
that shift. But to reset for the next shift like totals does every ward, I
tryed a overall calculate text and it worked for the first but then diddn't
reset for the next one
Click to expand...


Add an over group running sum text box to the ward(?) footer
and set its expression to be the same as the text box that
displays the ward total.
 
Back
Top