help summing in report footer

[barlee]

I want to sum only certain records in one text box, and a different group of records in another box, but i can't figure out how to write the equation.

I want to get the sum of amount paid for records where linecolumn = "F" and in another box get the sum of amount paid for records where linecolumn = "C".

I feel like I should know how to do this, but I'm drawing a blank.....

 

[HiTechCoach]

I want to sum only certain records in one text box, and a different group of records in another box, but i can't figure out how to write the equation.

I want to get the sum of amount paid for records where linecolumn = "F" and in another box get the sum of amount paid for records where linecolumn = "C".

I feel like I should know how to do this, but I'm drawing a blank.....

Try this in the control source of your text box:

=Sum(IIF([linecolumn] = "F", [amount paid],0))

and the other:

=Sum(IIF[linecolumn] = "C", [amount paid],0))


Note: Substitute the [linecolumn] and [amount paid] for the actual field names in the report's record soue4ce nad not he names of controls on the report.

 

[barlee]

Thanks HiTechCoach! That worked perfectly. I did figure that out last night about a half hour after I posted my question...good to know that I got it right. Thanks again!

BTW, I really appreciate this forum, it has helped me so much over the years....

 

[HiTechCoach]

Thanks HiTechCoach! That worked perfectly. I did figure that out last night about a half hour after I posted my quesion...good to know that I got it right. Thanks again!

BTW, I really appreciate this forum, it has helped me so much over the years....

Glad we could assist.