- Date (per month)
- Text 1
- Checkbox 1 (number)
- Checkbox 2 (number)
What I want to do is to calculate how many 'yes' are in checkfield 1 and how many in checkfield 2. In the criteria field I placed True for both of the checkboxes. Thing is, it doesn't calculate the values for each field seperately, but it always shows the same number.
Am I doing something wrong? Is it better to do this using DCount, and if so, how can I do this?
PS: I have translated 'number' from dutch to english (aantal) so I might have translated it slightly different than is shown in your access version
I have tried it but it doesnt work. I have placed the sum-functions in seperate fields but I get the anouncement that I am trying to run a query in a static function. Please could you let me know where to place what part of your code?