>

>select sum(quantity)*sum(price)/sum(quantity) as navgpriceB where fischetype= m.lcfishcode2 and ;
>between(ldate,m.ldfirst,m.ldend) into cursor CrsBuyings
>

>
>if navgpriceB=0 at CrsBuyings in some records i wantto use nearest price as a first date in 3rd query

First after ldend?

Also, the following expression doesn't make sense to me. Can you explain?

... sum(quantity)*sum(price)/sum(quantity)
is the same as
sum(price)