Search results

its same as simple Purchase Less Reserve less Sales nothing complicated

Dear All, Thanks for all the support given. i need to create an Access database where i can do as follow :- Products - can be purchased than make reserved for some project & if required to sale will be deducted from the stock. Current Stock Qty = Purchase - Reserved (too deducted from...

Required Sub Form Row Selected Product --> Total of Product Qty Purchased - Sales in Main Form from Sub Form

in a crosstab query based report can we make a filter if the value is Zero or Null, that row will be hide or removed from the report

on a crosstab query based report can we make a filter if the value is Zero or Null, row will be hide or removed.

TRANSFORM Sum(qryProductPurchase.SumOfQty) AS SumOfSumOfQty SELECT qryProductPurchase.Product, Sum(qryProductPurchase.SumOfQty) AS [Total Of SumOfQty] FROM qryProductPurchase GROUP BY qryProductPurchase.Product PIVOT qryProductPurchase.TypeofFolio; created CrossTabl Query, if the value is...

SELECT tblFolio.TypeofFolio, tblProducts.ProductCode, Sum(tblFolio.Qty) AS SumOfQty FROM tblProducts INNER JOIN tblFolio ON tblProducts.ProductsID = tblFolio.Product GROUP BY tblFolio.TypeofFolio, tblProducts.ProductCode; getting the total nos. of, but can you tell me how to make the report for...

Ok thanks for your suggestion, will do and update

screenshot relationship, inform if anything required to change

getting repeated rows duplicate

adding two query in one but getting duplicate records. SELECT [qryReserveFolio Query].Product, [qryReserveFolio Query].Qty, qrySalesFolio.Qty FROM [qryReserveFolio Query], qrySalesFolio; can anyone help, as its showing duplicate values/ rows