SUM

[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.

 

[Marshall Barton]

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.

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))