Question display only positive values in a query

[tselie115]

hello guys !
plz check the attached screenshot of ma query.
what im tryin to do is to display only positive values of the calculated field "extra" in the query.
if i try to put >=0 in the criteria row of "extra", it asks to fill the paramters "receivedqty1", "issuedqty1" and "balance1"
can anybody help!!! plzz

 

[namliam]

This is because you are referencing alias' in your calculations. You need to use the original calculation of the alias to be able to put in > 0

FYI:
IIF(Isnull(x),0,x), where x is any field can be replaced by... NZ(x,0) or even Nz(x)

 

[tselie115]

thanks for your help namliam but i replaced the IFF with NZ but no change occured.
in fact i used iff to be able to replace the null values with 0 to calculate the field "extra" when do data is in receivedqty or issuedqty.
any other idea that will allow me to use >=0 to show only positive values in this case?

 

[tselie115]

thanks for you help man!
its solved.
Please check my attachement to see it

 

[namliam]

Well technicaly you would have to do...
NZ(Sum()) + NZ(Sum()) + etc...
not NZ(Sum + sum + Etc)

But glad you worked it out