Thanks Tim,

Your following worked correctly after I have created the function Month. Let me try if I could succeed with this query. Thanks again for your help.

Regards
Vijay

>SELECT Month(trandate), sum(tranamt) AS tranamt FROM mytran ;
>WHERE bookyear = ?cAcctyear AND accode = ?nAccode ;
>GROUP BY Month(trandate), trantype