Access Checkbox and Sum (right post)

  • Thread starter Thread starter Miltos
  • Start date Start date
M

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
 
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
'====================================================
 
Thanks A lot John. That one worked. U r great and fast. Thanks again.

John Spencer said:
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
Click to expand...
Click to expand...
 
Back
Top