Hello everyone
I have a problem with ( sum ) in query
When I want to make (+) and ( - ) in query , it doesn't give me
for example : I have (sum of sales , sum of buy , sum of return from costumers , sum of return to production company and sum of damage)
I want to make Total for all of them
I used (IIF with " is null " ) but It's not gives me right choose
for every these tables , I made special query .
I used : IIF([sum of buy] is null ;0; [sum of buy] + IIF([sum of return from costumers] is null ;0;[sum of return from costumers] - IIF([sum of sales] is null ;0; [sum of sales] - IIF([sum of return to production company] is null ;0; [sum of return to production company] - IIF([sum of damage] is null ;0;[sum of damage])))))
even my report Store show me correct
I mean When I buy something and enter in buy invoice , it's appear in Store .
it's gives me this sentence .