>Nadya,
>
>The maximum value for an integer is 2,147,483,647. If you need a bigger number, you could try something like SUM(ytdval) + 0000000000.00 AS ytdval. This should (I think) convert the integer to a normal numeric, and just keep adding 0's until you have enough.
>
>Bill
Bill,
You're a genius! You save my live, thanks a bunch!!!!!!
If it's not broken, fix it until it is.
My Blog