1. This 

http://filemakerhacks.com/2012/09/13/aggregates-in-filtered-portals/

You can put summary fields in a portal and they will change based on the portal filter (in your case a date range).

Or 2. ExecuteSQL() to get the precise values you want. 


-- sent from myPhone --
Beverly Voth
--

> On Jul 9, 2014, at 7:43 PM, Jeff Hough <[log in to unmask]> wrote:
> 
> Hello,
> 
> We are working on a report project that requires data sub summaries from 2 different date ranges to appear on the same page. For example:
> 
> Widget Name    |    Total Qty for June 2014    |    Total Sales for June 2014    |    Total Qty for June 2013    |    Total Sales for June 2013
> 
> Does anyone have an example they could send me to shortcut the work. This is proving to be more time consuming that originally planned.
> 
> Thanks,
> Jeff