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