Code:
Sum(([a1000]+[a1001]+[a1003]+[a1002]+[a1004]+[a1005])*-1)
1 result in 0.0040 seconds.
-
SPC Camp started a topic What is the best way to build a db to report a total number of true yes/nos'?in AccessWhat is the best way to build a db to report a total number of true yes/nos'?
I am trying to build a db to report the deficiencies/strengths of security. We have about 1000 criterion that we base these on. I am trying to set it up to where we can specify which criteria they are deficient in, and it will report the total number of deficiencies that section has. i have tried to do this with a yes/no field, and code that looks a little like this:
in order...