Tom,

Would stored procedures still be preferable if the select statement constantly changes? I am not talking about parameters, but the fields in the select statement. I will have multiple users running the apllication and each of them will be changing the range of dates which means the sum() formaulas will be selecting different months/years for the calculated totals.

Kind Regards,

Mat

>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
>