stock report on fifo basis (1 Viewer)

gregor13

New member
Local time
Today, 07:16
Joined
Mar 20, 2020
Messages
1
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
 

Attachments

  • FifoGM5.zip
    119.2 KB · Views: 77

Ranman256

Well-known member
Local time
Today, 02:16
Joined
Apr 9, 2015
Messages
4,339
you want an OUTER join. This will show records that don't have a sale.
in query design, dbl-click the join line,
set 1 table (product) to SHOW ALL RECORDS,
the other (sales) to SHOW SOME RECORDS.
 

Users who are viewing this thread

Top Bottom