DCount criteria multiple variables

's Computer Specifications

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

's Computer Specifications

Sorted now thanks :-).

"hughess7" wrote:

> 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

's Computer Specifications

"hughess7" <(E-Mail Removed)> a écrit dans le message de
groupe de discussion : 59A28175-09DD-4A92-8119-(E-Mail Removed)...
> 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

Thread Tools
Show Printable Version Email this Page
Rate This Thread
Rate This Thread:

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
multiple criteria in dcount	=?Utf-8?B?cGpv?=	Microsoft Excel Misc	0	21st Jun 2007 03:02 PM
DCount with Multiple Criteria	=?Utf-8?B?VmFsaWRseXRl?=	Microsoft Access Queries	2	8th Nov 2006 08:38 PM
DCount with multiple criteria?	=?Utf-8?B?U2Vhbks2ODc2?=	Microsoft Access	1	22nd Dec 2005 04:30 PM
dcount with multiple criteria	Ramone	Microsoft Access VBA Modules	19	21st Aug 2004 12:29 AM
Dcount with Multiple Criteria	Ramone	Microsoft Access VBA Modules	1	19th Aug 2004 08:49 PM