RE: [MS_AccessPros] Dcount with string

 

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 (2)

Recent Activity:

• New Members 3

Visit Your Group

Switch to: Text-Only, Daily Digest • Unsubscribe • Terms of Use • Send us Feedback

.

__,_._,___