Search results

Ah.. Thank you. perhaps without VBA the above using query have result???

Thank you. But Query results are wrong... MonthlySummary.mdb File Required query. Example StartDate LastDate Amount 01/17/2012 01/18/2012 600 03/26/2012 04/01/2012 700 04/02/2012 06/10/2012 7000 12/31/2012 01/01/2013 400 I want to Result. Month SumValue 1 $800 (01/01/2013 = $200 +...

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...