If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Access Checkbox and Sum (right post)
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 |
#2
|
|||
|
|||
Access Checkbox and Sum (right post)
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 wrote: 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 |
#3
|
|||
|
|||
Access Checkbox and Sum (right post)
Thanks A lot John. That one worked. U r great and fast. Thanks again.
"John Spencer" wrote: 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 wrote: 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 |
Thread Tools | |
Display Modes | |
|
|