the result table that I need, each cancelation request as a column and add the total by day in the respective day)
>
>TOTAL QUOTES BY DAY WITH CANCELATIONS
>date client quotes Declined at begining Not Ended No Credit Card
John, I can give you a code sample, but I do have a question.
Are those column definitions fixed ( quotes, declined at beginning, not ended, no credit card), or could you have other reasons that equate to columns as well?