Count rows within a date range and a criteria

[Darin_Bellisari]

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…

Thank you!

[Databaser]

Hi @Darin_Bellisario

Is it an option to simply add a formula field with WEEKNUM() to get the week number from your date field and then group on that formula field to get the numbers of record in that week? You could add a view that only show the “checked” records.