how can I use the Sum function with an IIF?

[HockeyFan]

Is it possible to do a sum of field B, only when field A has the value of 1?
Example:
=IIf([A]="1",Sum(),"")

The problem with my statement above, is that it is doing a sum of all of the records of field B, whereas I only want it to sum the records that have a value of 1, in field A.

I want to use this statement as a control source for my form.

 

[SkipVought]

How about this...
[tt]
=SUM(IIf([A]="1",,0))
[/tt]


Skip,

_{Just traded in my old subtlety...
for a NUANCE!}

 

[HockeyFan]

This definately sounds like the right solution, but for some reason it's not working. could there be a syntax error?

 

[SkipVought]

What are the symptoms of "not working?"

Skip,

_{Just traded in my old subtlety...
for a NUANCE!}

 

[HockeyFan]

It says #Error.

 

[SkipVought]

What is the data type for [A]?

Skip,

_{Just traded in my old subtlety...
for a NUANCE!}

 

[HockeyFan]

field A, B, are both numeric.

 

[SkipVought]

Then why are you testing for a STRING???

=SUM(IIf([A]=1,[B],0))

Skip,

_{Just traded in my old subtlety...
for a NUANCE!}

 

[HockeyFan]

Skip, you da bomb!

Thanks. stupid mistake by me. I appreciate your help!

 

[SkipVought]

Francois: Do you know what kind of a bomb it was?
Clouseau: The exploding kind.

Skip,

_{Just traded in my old subtlety...
for a NUANCE!}