[MS_AccessPros] RE: Dcount with string

 

Try

=DCount("[UnitID]","tblUnit","[ClassificationType] = 'Rental'") 

---In MS_Access_Professionals@yahoogroups.com, <ms_access_professionals@yahoogroups.com> wrote:

=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 (5)

Recent Activity:

• New Members 4

Visit Your Group

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

.

__,_._,___