DCount criteria multiple variables

[hughess7]

Hi, please can someone correct this for me I just can't seem to quite get the
syntax right!!

Me![ClaimCount] = DCount("*", "[Warranty Data " & txtCountry & "]",
"[Dealer_Code] = '" & txtDealer & "' And SBI_Date > " & Format(dtDate,
"\#mm\/dd\/yyyy\#"))

Dealer_Code is text and SBI_Date is a date.

Thanks in advance for any help.
Sue

 

[hughess7]

Sorted now thanks .

 

[Madeleine hurtebise]

Hi, please can someone correct this for me I just can't seem to quite get
the
syntax right!!

Me![ClaimCount] = DCount("*", "[Warranty Data " & txtCountry & "]",
"[Dealer_Code] = '" & txtDealer & "' And SBI_Date > " & Format(dtDate,
"\#mm\/dd\/yyyy\#"))

Dealer_Code is text and SBI_Date is a date.

Thanks in advance for any help.
Sue