Need Help building a specific expression

[Setter00]

I work with a claim auditing company and our entire management system is in Access '97. I'm trying to build an expression to calculate the total $ amount of all records with a specific status. Unfortunately I get errors every way I try it. The basic idea of the expression I need is:

=Sum[AmountFiled]when([Status]=8)

Any ideas?

 

[Philly44]

If this is in a control this should basically do it

=iif([Status] = 8,Sum([AmountField]))

 

[JoeMiller]

This will sum like you're looking for in a control.

=DSum("[AmountFiled]","TableDataIsIn","[Status]=8&quot

HTH Joe Miller
joe.miller@flotech.net