M
Marta
I have a query that list member id#,the month and amt of the member has paid.
The query is program to only show those members that short paid the premium.
The report contains un/bounded Text boxes, that include formulas such as:
formula Text 33 =IIf([Tier]=1,11.06,IIf([TIER]=2,35.37,IIf([TIER]=3,21.49,"
"))) and formula JulTwoPercentDiff =([PAID JUL]-(0.02*[PAID JUL])) is
used in conjunction with Text 33 to form this formula JUL DIFF
=IIf([Text33]=11.06,11.06-[JulTwoPercentDiff],IIf([Text33]=35.37,35.37-[JulTwoPercentDiff],IIf([Text33]=21.49,21.49-[JulTwoPercentDiff],"
"))). I want to be able to add the value that is generated from the JUL DIFF
and add it to subsequent months for the same member ID. Is this possible?
Thank you
The query is program to only show those members that short paid the premium.
The report contains un/bounded Text boxes, that include formulas such as:
formula Text 33 =IIf([Tier]=1,11.06,IIf([TIER]=2,35.37,IIf([TIER]=3,21.49,"
"))) and formula JulTwoPercentDiff =([PAID JUL]-(0.02*[PAID JUL])) is
used in conjunction with Text 33 to form this formula JUL DIFF
=IIf([Text33]=11.06,11.06-[JulTwoPercentDiff],IIf([Text33]=35.37,35.37-[JulTwoPercentDiff],IIf([Text33]=21.49,21.49-[JulTwoPercentDiff],"
"))). I want to be able to add the value that is generated from the JUL DIFF
and add it to subsequent months for the same member ID. Is this possible?
Thank you