Mat;

That is great news. I did something similar recently.

Two good reasons to use stored procedures to gather data are:

1. Increased speed.
2. Less network traffic.

Tom

>Tom,
>
>Thank you for the reply. I am just trying to gather some summary information for text boxes on a start up page. From there the users can drill down into the detail. These queries will be very dynamic based on the user selected range of dates.
>
>Using the totals in another column allows me to calculate a range of months and then use those totals for other calculations. I can add up the quarter totals for annual amounts and then subtract the annual totals from a base amount to get net results. This is much cleaner than continually dealing with the individual months.
>
>The answer Mike gave me works perfectly for what I am trying to accomplish.
>
>Kind Regards,
>
>Mat
>
>>These requests may not be as easy as they sound.
>>
>>1. Is it possible to define the requirement?
>>2. How many tables?
>>3. Are you filling a data grid or HTML table?
>>
>>I thought I knew what you were attempting to do but I am not sure at this point. The part “use those totals in another column” is what throws me.
>>
>>Tom