Access Checkbox and Sum (right post)

[Miltos]

Hello. I need some help for this access db.
doseis check
50 y/n
50 y/n
50 y/n
i tryed to sum doseis only if check=0 like this:
=IIf([check]=0;sum([doseis])) but it didn't work when i check it.
Can anyone help me with that? Thnx

 

[John Spencer]

Try the following:
= Sum(IIF([Check]=0,[DoseIs],Null))



'====================================================
John Spencer
Access MVP 2002-2005, 2007-2009
The Hilltop Institute
University of Maryland Baltimore County
'====================================================

 

[Miltos]

Thanks A lot John. That one worked. U r great and fast. Thanks again.

Try the following:
= Sum(IIF([Check]=0,[DoseIs],Null))



'====================================================
John Spencer
Access MVP 2002-2005, 2007-2009
The Hilltop Institute
University of Maryland Baltimore County
'====================================================

Hello. I need some help for this access db.
doseis check
50 y/n
50 y/n
50 y/n
i tryed to sum doseis only if check=0 like this:
=IIf([check]=0;sum([doseis])) but it didn't work when i check it.
Can anyone help me with that? Thnx