Forum Discussion

gcreed's avatar
gcreed
Copper Contributor
Apr 17, 2021

stock QTY ON HAND problem

AvailableQuantity: Sum([totalPurchaseData].[purchase_item_quantity])+(Nz((SELECT SUM(QuantityTransferred) FROM Transfers WHERE Transfers.ItemCode = [totalPurchaseData].[Item Code] AND Transfers.WareH...
2016
access
George_Hepworth's avatar
George_Hepworth
Silver Contributor
Apr 17, 2021

gcreed 

Is this supposed to be a query? If so, it appears to have been only partially copied into your post.

Also, what does it mean to say "...the quantity won't show the transfer + value." What DOES it show instead? An error? The wrong sum? Or something else?

Thanks.