Sabtu, 26 Oktober 2013

Re: [MS_AccessPros] Dcount with string

 

Jim,
Thank you that was it exactly!!! Works like a champ.
 

With Warm Regards,
 
Arthur D. Lorenzini
IT System Manager
Cheyenne River Housing Authority
Wk.(605)964-4265  Ext. 130
Fax (605)964-1070
"Only those who will risk going too far can possibly find out how far one can go."






On Friday, October 25, 2013 7:25 PM, Jim Wagner <luvmymelody@yahoo.com> wrote:
 
I just did a dcount and this is what I did and it works. Maybe you are missing the quotes on the last string
 
="Records on the report is " & " " & DCount("*","In CurrentVacEmplTable Not in TMA")
 
Jim Wagner


On Friday, October 25, 2013 3:45 PM, Graham Mandeno <graham@mandeno.com> wrote:
 
Hi Arthur
 
/Rental/ is a literal text value, so it must be enclosed in quotes like this:
=DCount("[UnitID]","tblUnit","[ClassificationType] = 'Rental' ")
 
Without the quotes, SQL would look unsuccessfully for a field named "Rental" to match with the field named ClassificationType"
 
Best wishes,
Graham
 
From: MS_Access_Professionals@yahoogroups.com [mailto:MS_Access_Professionals@yahoogroups.com] On Behalf Of dbalorenzini@yahoo.com
Sent: Saturday, 26 October 2013 11:15
To: MS_Access_Professionals@yahoogroups.com
Subject: [MS_AccessPros] Dcount with string
 
 
=DCount("[UnitID]","tblUnit","[ClassificationType] = Rental")
 
But I keep getting an error. I think it has to do with =Rental" but not sure how to correct it. Any ideas?
 
Thank you,
 
Arthur Lorenzini
Sioux Falls, SD 




__._,_.___
Reply via web post Reply to sender Reply to group Start a New Topic Messages in this topic (4)
Recent Activity:
.

__,_._,___

Tidak ada komentar:

Posting Komentar