Hi all,
I have created a query based on a two table and created a query to combined the information from the two tables. I have having issue whereby my balance amount is not reflected when the issued quantity = 0. How to reflect the balance qty?
Formula in the query:
Balance: Sum([ReceivedQuantity]-[IssuedQuantity])