Thanks alot. That work perfectly.
With warm regards,
Arthur Lorenzini
Sioux Falls, South Dakota
________________________________
From: Duane Hookom <duanehookom@hotmail.com>
To: Access Professionals Yahoo Group <ms_access_professionals@yahoogroups.com>
Sent: Tuesday, November 29, 2011 4:29 PM
Subject: RE: [MS_AccessPros] And statementin DCOUNT
=DCount("*","[tblHousehold]","[StudentID]=" & [StudentID] & " AND MemberTypeID =1")
Duane Hookom
MS Access MVP
To: MS_Access_Professionals@yahoogroups.com
From: dbalorenzini@yahoo.com
Date: Tue, 29 Nov 2011 22:26:16 +0000
Subject: [MS_AccessPros] And statementin DCOUNT
I have the following DCOUNT statement:
=DCount("*","[tblHousehold]","[StudentID]=" & [StudentID])
How would I add in AND MemberTypeID = 1
Thank you,
Art
Sioux Falls, SD
[Non-text portions of this message have been removed]
------------------------------------
Yahoo! Groups Links
[Non-text portions of this message have been removed]
Tidak ada komentar:
Posting Komentar