I am not an expert, but work with a Pathology Lab database (Access2000). Every quarterly inventory a report is prepared giving use of some 1200 products. This is derived as (beginning inventory count)+(purchases received)-(end inventory count). This gives the number of items used. This can then be *UnitPrice and give the cost of product per workstation and/or machine.
BUT out of the 1200 we always have 70 or 80 with NEGATIVE use (!!) - these errors then have to be tracked down.
QUESTION: Is there any way to make the report print ONLY these negative items ? The item in question looks like: Sum([Total]). There is an underlying query - qryrptLabSupplies.
It would be equally useful to be able to print a table limited to negative use items - maybe more useful...
Thanks for any suggestions.
BUT out of the 1200 we always have 70 or 80 with NEGATIVE use (!!) - these errors then have to be tracked down.
QUESTION: Is there any way to make the report print ONLY these negative items ? The item in question looks like: Sum([Total]). There is an underlying query - qryrptLabSupplies.
It would be equally useful to be able to print a table limited to negative use items - maybe more useful...
Thanks for any suggestions.
