June 7, 200421 yr Newbies Sorry, but I'm a stupid newbie. I am totally lost, but here's what I'm trying to do: I have a "yes" and "no" check box. When yes is checked, I'm trying to get a field to keep track of the number of times it is checked whether it be yes or no. For example, the database keeps track of number of jobs won and lost. So the final result should be something like this: 9 out of 10 jobs were won resulting in a job-received rate of 90 percent. I am so lost I don't even know where to start...
June 7, 200421 yr Is this one field with the choice of Yes or No? If so make 2 calculated number fileds. Won = Case ( Ans = "Yes", 1, 0) and Lost = Case ( Ans = "No", 1, 0). Make summary fields that total Won and Lost.
Create an account or sign in to comment