How to combine two query which have the same column name to be another

[djungna]

Hi friend
I need your help.
I have made 2 query (named "QryReceivesum" & "QryWithdrawsum").
But query have the same common column called "ProductId".
I want to combine 2 query to be just one.

Currently I have mae one query named "QryStock".
but the data from this qry is not correct.

As you can see, it doesn't show the number of product from productID3.


can anyone help me??

 

[djungna]

Thank you so much

Thank you so much Hartman
it works!!!!

 

[djungna]

How to use formular with the cell without value

Hi hartman

Now I can make the summary of "Receive" and "withdraw" for each product.
In some row, there are both value for "receive" & "withdraw", so i can deduct "receive" & "withdraw".

But in some row, there is only "Recieve" and no value for "withdraw" (the cell is blank but not zero), so i can not deduct it.

How i can i make the deduction for all row, even there is no data in "receive" or "withdraw".

please see "Qrystock".

Thank you so much

 

[djungna]

Ask some more about NZ function

Dear Hartman
Can you please guide me little more.
How can I use this Nz function.

I have try to put this function in Properties of "SumOfReceiveQty" text box.

and this what i put in (i search from help and adapt with your command)

Dim A as variant
A = Nz(A, 0)

But it doesn't work.

Thank you in advance for your help

 

[djungna]

Ask some more about Nz(SumOfReceiveQty,0)

To HJartman
I have try by Adding =Nz(SumOfReceiveQty,0) in ControlSource property of "Frmstock" in "Sumofreceiveqty" text box.

but is show error when open the form..

Could you please advise me little more