>Dear Sir,
>
>The code field is character type
>You wrote
>

>SUM(IIF((INT(t2.code/1000)) = 3201,t2.credit,0)) as amt1,;
>

>and to change character to number I modified as
>

>SUM(IIF(INT(VAL(t2.code/1000)) = '3201',t2.credit,0)) as amt1,;
>

>But it still shows error "Data type mismatch"
>
>Please help again

SUM(IIF(left(t2.code,4) = '3201',t2.credit,0))

Cetin