Expression Help

[Guest]

I am trying to calculate the sum of a field in a query or table based on the
value of a second field in that query or table. Such as if field A is
greater than 24, add all values in Field B.

 

[JohnFol]

Hi Jason, is this in code, within a single query or where? Is there a
relationship between table a and b?

For example if in code you could do

If Me!FieldFromTableA > 24 Then
MySum = DSum("FieldFromTableB","TableB")
End if

 

[Guest]

This is within a single query and there is a relationship between the
tables/queries.

Thanks
JM

 

[John Spencer (MVP)]

Try a calculated field.

SUM(IIF(FieldA>24,FieldB,0)