>selectsum(quantity)*sum(price)/sum(quantity) as navgpriceB where fischetype= m.lcfishcode2 and ;
>between(ldate,m.ldfirst,m.ldend) intocursor 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 sameassum(price)