SUM

  • Thread starter Thread starter CHRIS B.
  • Start date Start date
C

CHRIS B.

I am tring to get a total of the field [Points]in the
footer of a form. However I need three different totals,
one if [Type_QRS]="Q", one if [Type_QRS]="R", and one if
[Type_QRS="S"]. I have tried to create three temp fields
in the form as tq, tr, and ts. I set these fields = to
[Points] based on [Type_QRS] and they work, however, when
I try to sum([tq]) in the footer I get an error. Please
HELP!

Chris.
 
CHRIS said:
I am tring to get a total of the field [Points]in the
footer of a form. However I need three different totals,
one if [Type_QRS]="Q", one if [Type_QRS]="R", and one if
[Type_QRS="S"]. I have tried to create three temp fields
in the form as tq, tr, and ts. I set these fields = to
[Points] based on [Type_QRS] and they work, however, when
I try to sum([tq]) in the footer I get an error.
Click to expand...


Sorry, but I don't understand what you've tried.

You can get the total for each type by using form footer
text boxes with expressions like:

=Sum(IIf[Type_QRS]="Q", Points, 0))
 
Back
Top