DCount criteria multiple variables

  • Thread starter Thread starter hughess7
  • Start date Start date
H

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 said:
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
Click to expand...
 
Back
Top