DCount syntax problem

[Binnit]

I have 2 Dcount statements that I need to join the WHERE clauses.

Both statements work correctly independantly but when I try to add an AND and join it together it fails, I am presuming this to be a syntax issue and have tried many variances to get it right but so far no success.

Any help appreciated.

DCount("[CNNumberFrom]", "tblCoverNotes", "[CNIssuedTo] =" & Me.txtIssuedTo)

DCount("[CNNumberFrom]", "tblCoverNotes", "[CNRSABookType] ='" & Me.txtCNRSABookType & "'")

What I need is the internal syntax to make the following WHERE clause work:-
DCount("[CNNumberFrom]", "tblCoverNotes", "[CNRSABookType] = Me.txtCNRSABookType AND [CNIssuedTo] = Me.txtIssuedTo")


[CNRSABookType] is a String
[CNIssuedTo]is a number


Happiness is...not getting what you want but wanting what you have already got

 

[Binnit]

OK, I got it.....at last!

DCount("[CNNumberFrom]", "tblCoverNotes", "[CNRSABookType] ='" & Me.txtCNRSABookType & "' And [CNIssuedTo] = " & Me.txtIssuedTo)

Happiness is...not getting what you want but wanting what you have already got