I've been doing this manually for years, and I cant' stand it any longer. I'll give an example of the type of aggregate summary's that I'm looking for. Let's say I'm running a bookings report for the year of 2005. I want to be able to have it automatically calculate the total dollar values based on Customer Name and only for the year of my choice. I can kind of get close to that now, but I still have to export the data into excel pivot table in order for me to have the dollars roll up on the customer name. I can never seem to get that last part to work. Once I can get a solution for this, I'll be able to use it for a lot of different reports that I've been running for too long.