Search results

Hi. How to configure the query? Please Help. Table1 ( Date Format : mm/dd/yyyy ) StartDate LastDate Value 01/17/2012 01/18/2012 $600 03/26/2012 04/01/2012 $700 I want to Query1. Query1 Month SumValue 1 $600 3 $600 (3/26 ~ 4/1 = 7Day 3Month = 6Day , 4Month = 1Day) 4...