Group SubTotal with condition

[dgrosh]

In my report.. I have many different groups. I have a Group Header that
inserts a page break in between the various groups... Each line item in the
table is identified by Asset or Liability. I need to total all the Assets
and then the Liabilities in the Group Header. I think I need an IF
Statement. This is the statement I came up with but it's not quite right.

=Sum(IIf([asset/liability]=[asset],([prior qtr],0)))
=Sum(IIf([asset/liability]=[liability],([prior qtr],0)))

Asset/Liability is a header in my table. What I'm trying to say.... If
Asset/Liabilities equals asset, give me the sum of the amounts in the prior
qtr fields.

 

[Duane Hookom]

Your asset and liability values are strings, not fields.
Try:
=Sum(Abs([asset/liability]="asset") *[prior qtr])
=Sum(Abs([asset/liability]="liability") *[prior qtr])

 

[dgrosh]

Thank you Very Much.... Exactly what I needed. Appreciate the help!!

Your asset and liability values are strings, not fields.
Try:
=Sum(Abs([asset/liability]="asset") *[prior qtr])
=Sum(Abs([asset/liability]="liability") *[prior qtr])

--
Duane Hookom
Microsoft Access MVP

In my report.. I have many different groups. I have a Group Header that
inserts a page break in between the various groups... Each line item in the
table is identified by Asset or Liability. I need to total all the Assets
and then the Liabilities in the Group Header. I think I need an IF
Statement. This is the statement I came up with but it's not quite right.

=Sum(IIf([asset/liability]=[asset],([prior qtr],0)))
=Sum(IIf([asset/liability]=[liability],([prior qtr],0)))

Asset/Liability is a header in my table. What I'm trying to say.... If
Asset/Liabilities equals asset, give me the sum of the amounts in the prior
qtr fields.