Sum Where Field

[mtownbound]

Need to create a simple subtotal field in a report using the expression builder similar to:

Sum([Field A] and [Field B]) where [City] = "Tallahassee"

Any ideas,


Thanks!!

 

[dhookom]

=Sum((A+B)*Abs([City] = "Tallahassee"))


Duane
Hook'D on Access
MS Access MVP

 

[mtownbound]

Great, thanks!!