I've got a large sweaty query that draws from three others because of a speed issue. The whole thing calculates MPG for a fleet and it uses a bunch of aggregates to come up with Min and Max odometers in a range and the sum of gallons (minus the sum of the first fuel) between a range of dates. I currently have all this going out to a report that recaps fuel consumption. I split it into three queries to speed it up. Now I would like to run this report for three separate date ranges (4 week) periods and put them all on the same report. What is the best way to go about this. Re write the underlying queries to do the same thing for 3 date ranges and build one big set of results. Use the same query three times and take the original report and build recordsets for the other periods and slap in values as the report formats or what? Any comments appreciated. TIA