|
| 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
July 17th, 2009, 01:24 AM
posted to microsoft.public.access.queries
|
|||
|
|||
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
July 17th, 2009, 02:04 AM
posted to microsoft.public.access.queries
|
|||
|
|||
|
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
July 17th, 2009, 02:13 AM
posted to microsoft.public.access.queries
|
|||
|
|||
|
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 | |
|
|
Linear Mode
