 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
MS Access Forum / Reports / Printing / March 2007conditional count function
can I do =Count([Q6=1]) ? How do I write a statement to count all answers to Q6 where option=1 in a report? Please help! TIA. > can I do =Count([Q6=1]) ? > How do I write a statement to count all answers to Q6 where option=1 in a > report? > Please help! > TIA. You wish to determine the number or times field [Q6] equals 1? In an unbound control: =Abs(Sum([Q6] = 1)) ([Q6] = 1) is evaluated as either True or False (-1 or 0) Sum() adds the -1's and 0's. Abs() returns the positive value.  SignatureFred Please respond only to this newsgroup. I do not reply to personal e-mail |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.