Search results

I have check again. Now it work everything. Many thanks arnelgp,

Thank you plog and arnelgp, I try this and now it almost near my expect result but the calculation is not all correct. As Nz function , it make some value in OutQuantity to zero. I do not know what is the cause? . It can change null in OutQuantity to zero but it also change some value...

Thank you jdraw for your reply. I use this code. SELECT TableX.Customer, TableX.Product, TableX.InQuantity, TableZ.OutQuantity, [TableX].[InQuantity]-[TableZ].[OutQuantity] AS Balance FROM TableX INNER JOIN TableZ ON (TableX.Product = TableZ.Product) AND (TableX.Customer =...

Dear all, I have two tables and I want to calculate the balance. Table X ( record the product I sent to customer) Customer------Product-----InQuantity AAA------------A1-----------2 AAA------------A2-----------1 AAB------------A1-----------3 AAB------------A2-----------3 Table Z...