Hi all! Thanks in advance for any advice or help!
We’ve got the following situation:
- We have a table with a Date field, so each entry has a date
- Each entry also has a checkbox field (so checked or unchecked)
We would like to do the following:
- In another table, for each week get a sum of the number of entries in the other table that (a) occured during that week, and (b) have the checkbox checked
Does anyone know how to do this? We’ve been playing with roll-ups and counts but we can’t seem to find a solution that doesn’t require linking to every entry in the table…