Conditional Sum

[Guest]

I have a continuos form the key items of which are [dblContribution] and
[dteCeased]

I want to sum contributions currently being paid ie. [dblContribution] where
[dteCeased] is blank, what's the best way to go about it?

I've tried setting up an additional text box on the form (called txtCrntCbn)
with the formula =IIf(IsNull([dteCeased]),[txtContribution],0) and I have
=Sum([txtCrntCbn]) in the form footer however all I get for the Sum() result
is #Error


This may be connected to a problem I had about 10 posts ago in this forum
entitled "Sum() in Form Footer" I seem to have a lot of problems with Sum()
in continuous forms - it functions rather arbitrarilly for me I'd be
grateful if anyone has any ideas why this is.

Im running Windows and Access 2000

Thanks in advance for your help

Simon

 

[Guest]

Try using DSum. In the form footer you would use a text box containing
something like:
=DSum([dblContribution],"TableName","[dteCeased] Is Null")

See Help and the following for more:

http://support.microsoft.com/default.aspx?scid=kb;EN-US;121509
http://support.microsoft.com/kb/103183/EN-US/

 

[Guest]

Thanks Bruce - the DSum worked a treat