My query returns $8400:
Click image for larger version. 

Name:	Capture.PNG 
Views:	8 
Size:	71.3 KB 
ID:	45176

Using Dsum will be slow, if you only want one at the time you can use the custom function as the control source and do a Me.Recalc in the after update events of the from\to combos.

Normalizing could be easier if you follow my union example, just continue to add the Select statements until you reach the end month.



Cheers,