PC Review


Reply
Thread Tools Rate Thread

DCount criteria multiple variables

 
 
hughess7
Guest
Posts: n/a
 
      28th Apr 2009
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
 
Reply With Quote
 
 
 
 
hughess7
Guest
Posts: n/a
 
      28th Apr 2009
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

 
Reply With Quote
 
Madeleine hurtebise
Guest
Posts: n/a
 
      28th Apr 2009


"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


 
Reply With Quote
 
 
 
Reply

Thread Tools
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off


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


Features
 

Advertising
 

Newsgroups
 


All times are GMT +1. The time now is 01:14 AM.