Hi,
i am new to Access and need a help with a report, which doesn't show all records. The problem is with products that have been purchased, but don't have a sale yet. This products don't shows up in "StockReportOnFifoBasis". I figured out that the problem is in the Query --> "QryStockAvailable" ---> "AvailableQty: IIf([TSale]>[popn];[pruntot]-[TSale];[pqty])". If i add a sale record for the product with value 0, then everything works fine. Is there a way to let say generate automatically a sale with 0 value, whenever i purchase a new product? I have attached a sample DB.
Thank you
i am new to Access and need a help with a report, which doesn't show all records. The problem is with products that have been purchased, but don't have a sale yet. This products don't shows up in "StockReportOnFifoBasis". I figured out that the problem is in the Query --> "QryStockAvailable" ---> "AvailableQty: IIf([TSale]>[popn];[pruntot]-[TSale];[pqty])". If i add a sale record for the product with value 0, then everything works fine. Is there a way to let say generate automatically a sale with 0 value, whenever i purchase a new product? I have attached a sample DB.
Thank you