Hello everyone
I have a problem with function NZ in Query if someone can help me about it , I will be so pleased
I have 4 queries
( buy invoice , sale invoice , customers Return and To products return )
this is my Table for all
I made this for all 4 invoice in Query :
and after that I used Nz for two tables ( buy invoice and customers return ) because both are add in inventory
and I made for ( sale invoice and products return ,,, I mean I return something to the products ) in another query
and for Quantity I made the same and also for sale invoice too
but I don't know why it isn't appear
and after that I made special query for ( total buy and total sale )
I want when I enter data in buy invoice automatically it enter zero in other , even my inventory appear