I have a table that captures up to 10 dates and 10 memos (one for each date). I am trying to create a query/report that sums that amount of time a date shows between a range.
Example:
Record #1:
Date#1: Jan/02/2016 Memo: some memo
Date#2: Jan/05/2016 Memo: some memo
Date#3: Jan/30/2016 Memo: some memo
Date#4: Feb/02/2016 Memo: some memo
Record #2:
Date#1: Jan/03/2016 Memo: some memo
Date#2: Jan/10/2016 Memo: some memo
Date#3: Feb/08/2016 Memo: some memo
If I picked the dates Jan/01/2016 to Jan/31/2016, the report would show 5. (5 dates are in Jan)
I hope that's pretty clear. I am in the midst of creating the query and have pulled all 10 date fields but now I am stuck. Do I display them all then have some sort of SUMIF on the report?
Thanks,
Robb