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...
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Selecting data 2
Type Mismatch 5
Access Dcount (multiple criteria) 3
Creating data via code 12
Access MS Access DCount function problem 0
Using DCount and British dates 3
DCount with Date criteria 2
Getting DCount() to work correctly 2

Back
Top