By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,455 Members | 2,157 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,455 IT Pros & Developers. It's quick & easy.

How to use Dcount with condition

100+
P: 134
Hi, How can I count how many record, for example in my PO , there are 3 items under PO = 111, there is a "Selected" column = Yes or NO", I want to know how many was selected, in this example, total selected was 2.
I don't think dcount allow with condition, but not sure how to use the count command.


PO item Selected
111 zzz Yes
111 kkk No
111 ppp Yes
Jan 6 '08 #1
Share this Question
Share on Google+
1 Reply


100+
P: 134
Hi, How can I count how many record, for example in my PO , there are 3 items under PO = 111, there is a "Selected" column = Yes or NO", I want to know how many was selected, in this example, total selected was 2.
I don't think dcount allow with condition, but not sure how to use the count command.


PO item Selected
111 zzz Yes
111 kkk No
111 ppp Yes
Hi Sorry I manage to use the dcount to solve, thanks for visiting this page.
Jan 6 '08 #2

Post your reply

Sign in to post your reply or Sign up for a free account.