G
Guest
I have an inventory database, in one query i want to show total parts in stock.
the tables I have are TblAcq ( main inventory ) and WOCheckout ( Parts
going out to a jobsite ) When I tell it to use the "In Stock" from TblAcq
minus the "Quantity" from WOCheckout i ge the correct values, but it only
shows items from TblAcq that have a part also on WOCheckout... For instance
if ther are Ten differnt items checked out, But TblAcq has 800 parts in it,
the query only shows the Ten differnt parts correct sum, and show none of the
rest of the parts at all. How do I get it to show the rest of the parts in
quantity?? ( which would be In Stock - 0 since none are chceked out )
right now I have a simple [In Stock] - [Quantity] in a sum format in the
query
[In Stock] is the colum from TableAcq and [Quantity] is from it's colum in
WOCheckout
thanks for any help!
the tables I have are TblAcq ( main inventory ) and WOCheckout ( Parts
going out to a jobsite ) When I tell it to use the "In Stock" from TblAcq
minus the "Quantity" from WOCheckout i ge the correct values, but it only
shows items from TblAcq that have a part also on WOCheckout... For instance
if ther are Ten differnt items checked out, But TblAcq has 800 parts in it,
the query only shows the Ten differnt parts correct sum, and show none of the
rest of the parts at all. How do I get it to show the rest of the parts in
quantity?? ( which would be In Stock - 0 since none are chceked out )
right now I have a simple [In Stock] - [Quantity] in a sum format in the
query
[In Stock] is the colum from TableAcq and [Quantity] is from it's colum in
WOCheckout
thanks for any help!