DCount with one single condition works, but several ones, joined together with the logical operator AND, do not!
in [Getting Started]
|
Prev: Change receiving email for microsoft.public.access.gettingstarted group
Next: DCount with one single condition works, but several ones, joinedtogether with the logical operator AND, do not!
From: Henrik Jansson on 9 Feb 2010 12:51 Dear friends out there, I simply do not understand this. What's wrong with the syntax in my Access-2007 report? =DCount("[ID]", "Table", "[ConditionYesNo1] = No") -----> returns a correct minor total of all records with no checkmarks in the field (column) "ConditionYesNo1". =DCount("[ID]", "Table", "[ConditionYesNo1] = No" AND "[ConditionYesNo2] = No" ) -----> returns ALL records. Why i that? Thanks in advance Henrik __________ Information fr�n ESET NOD32 Antivirus, version av virussignaturdatabas 4848 (20100208) __________ Meddelandet har kontrollerats av ESET NOD32 Antivirus. http://www.esetscandinavia.com
From: Henrik Jansson on 9 Feb 2010 14:16
Thank you so much John! That solved my problem. Best regards, Henrik "John Spencer" <spencer(a)chpdm.edu> skrev i meddelandet news:O4Po5JbqKHA.5940(a)TK2MSFTNGP02.phx.gbl... > Try the following correctly formatted argument. > > =DCount("[ID]", "Table", "[ConditionYesNo1] = No AND [ConditionYesNo2] = > No" ) > > > John Spencer > Access MVP 2002-2005, 2007-2010 > The Hilltop Institute > University of Maryland Baltimore County > > Henrik Jansson wrote: >> Dear friends out there, >> >> I simply do not understand this. What's wrong with the syntax in my >> Access-2007 report? >> >> =DCount("[ID]", "Table", "[ConditionYesNo1] = No") -----> returns a >> correct minor total of all records with no checkmarks in the field >> (column) "ConditionYesNo1". >> >> =DCount("[ID]", "Table", "[ConditionYesNo1] = No" AND "[ConditionYesNo2] >> = No" ) -----> returns ALL records. Why i that? >> >> Thanks in advance >> >> Henrik >> >> __________ Information fr�n ESET NOD32 Antivirus, version av >> virussignaturdatabas 4848 (20100208) __________ >> >> Meddelandet har kontrollerats av ESET NOD32 Antivirus. >> >> http://www.esetscandinavia.com >> >> >> > > __________ Information fr�n ESET NOD32 Antivirus, version av > virussignaturdatabas 4848 (20100208) __________ > > Meddelandet har kontrollerats av ESET NOD32 Antivirus. > > http://www.esetscandinavia.com > > > __________ Information fr�n ESET NOD32 Antivirus, version av virussignaturdatabas 4848 (20100208) __________ Meddelandet har kontrollerats av ESET NOD32 Antivirus. http://www.esetscandinavia.com |