DCount with one single condition works, but several ones, joined together with the logical operator

  • Thread starter Thread starter Henrik Jansson
  • Start date Start date
H

Henrik Jansson

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
 
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
 
You made it more complex than required:

=DCount("[ID]", "Table", "[ConditionYesNo1] = 0 AND [ConditionYesNo2] = 0" )

You could also try
=DCount("[ID]", "Table", "[ConditionYesNo1] + [ConditionYesNo2] = 0" )
 
Thank you so much John! That solved my problem.

Best regards,

Henrik

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

__________ Information från ESET NOD32 Antivirus, version av
virussignaturdatabas 4848 (20100208) __________

Meddelandet har kontrollerats av ESET NOD32 Antivirus.

http://www.esetscandinavia.com
Click to expand...


__________ Information från ESET NOD32 Antivirus, version av virussignaturdatabas 4848 (20100208) __________

Meddelandet har kontrollerats av ESET NOD32 Antivirus.

http://www.esetscandinavia.com
 
Back
Top