getting as sum for check boxes
Okay I don't think I worded this correctly last time. I have a bunch of issue (boy do I) that are check boxes. I want to create a layout where it will show me the total number of times a issue was choosen during a period of time.
issues:(all check Boxes)
What I want is to know that between 9/1/09...9/30/09
late = 5
lazy = 7
sleepy = 10
hungry = 2
Hope this helps define what I am trying to do. Thanks
I've already posted a suggested solution in your other thread: Counting checks in check boxes
The method describe there will do the job, though you'll need a more sophisticated relationship.
Define a pair of global text fields: gDate1, gDate2
Set up your relationship to be:
Table::gDate1 < Table2:: DateField AND
Table::gDate2 > Table2:: DateField AND
Table::ValueField = Table2::CheckboxField