Thanks, I got it to work.
My mistake was instead of this:
Select iif(ConvrtDate>0,000000+Responders,0) as Converted ...
I should have done this:
Select 000000+iif(ConvrtDate>0,Responders,0) as Converted ...
Aloha,
James
>Try
Select 000000 + myfield as newMyfield ...
>
>
>>Hi All,
>>
>>How do I control the column width for a numeric column in a SQL result set.
>>
>>I'm using the CrossTab foundation class and am getting an data overflow error. On one of the queries I did this:
>>
>>
>>Select 000001 as Mailed ...
>>
>>
>>and it fixed the problem. However now I need to use the data from a field. I tried expanding the field width but that didn't work.
>>
>>Thanks in advance for any help.
>>
>>Aloha,
>>
>>James