Add more conditions to DCount textbox 2

[Sandman007]

I'm using the following:
=DCount("*","tbl","[columnX] = 'A'&quot
I'd like to add a condition that says columnX = A and columnY=B.
Can I do that. Anyone have the syntax?

 

[LDeMaio]

=DCount("*","tbl","[columnX] = 'A'&quot

To add more conditions:

=DCount("*","tbl","[columnX] = 'A' and [columnY] = 'B'&quot

if using variables:

=DCount("*","tbl","[columnX] = '" & VarA & "' and [columnY] = '" & varB & "'&quot

In the above example remove the single apostrophes if the variable contains a number and change them to pound (#) signs if they contain date string.

You can add more if needed following the same pattern.

Hope this helps.

Larry DeMaio
SDC