hi,
thank you ,i get only empty fields.

>try,
>
>SELECT stk_code,trn_type,trn_date,cst_prce,str_nmbr, ;
> SUM(trn_qnty) AS m1_t ;
> FROM test ;
>WHERE !isnull(trn_qnty) and MONTH(trn_date)=1 AND trn_type=1 and between(trn_date,ldStart,ldEnd) ;
>GROUP BY stk_code,trn_type,trn_date,cst_prce,str_nmbr