Printing zero stock items in inventory database

[Guest]

How do I print a report of zero stock items in the Inventory Management
database?

 

[Arvin Meyer [MVP]]

How do I print a report of zero stock items in the Inventory Management
database?

Base the report on a query like this as a source:

SELECT Products.ProductID, Products.ProductName,
[UnitsReceived]-([UnitsSold]=[UnitsShrinkage]) AS InStock
FROM Products INNER JOIN [Inventory Transactions] ON Products.ProductID =
[Inventory Transactions].ProductID
WHERE ((([UnitsReceived]-([UnitsSold]=[UnitsShrinkage]))=0));
--
Arvin Meyer, MCP, MVP
Microsoft Access
Free Access downloads
http://www.datastrat.com
http://www.mvps.org/access

 

[Guest]

Many thanks

I will copy and paste your solution to construct a query.

Thanks aagain

 

[Arvin Meyer [MVP]]

Before cutting and pasting, you may want to correct my typo (I missed the
shift key). You might also want to allow for possible missing numbers. Try:

SELECT Products.ProductID, Products.ProductName,
NZ([UnitsReceived])-(NZ([UnitsSold])+NZ([UnitsShrinkage])) AS InStock
FROM Products INNER JOIN [Inventory Transactions] ON Products.ProductID =
[Inventory Transactions].ProductID
WHERE (((NZ([UnitsReceived])-(NZ([UnitsSold])+NZ([UnitsShrinkage])))=0));
--
Arvin Meyer, MCP, MVP
Microsoft Access
Free Access downloads
http://www.datastrat.com
http://www.mvps.org/access

 

[Guest]

Thanks again for the info...

Rapradio

Before cutting and pasting, you may want to correct my typo (I missed the
shift key). You might also want to allow for possible missing numbers. Try:

SELECT Products.ProductID, Products.ProductName,
NZ([UnitsReceived])-(NZ([UnitsSold])+NZ([UnitsShrinkage])) AS InStock
FROM Products INNER JOIN [Inventory Transactions] ON Products.ProductID =
[Inventory Transactions].ProductID
WHERE (((NZ([UnitsReceived])-(NZ([UnitsSold])+NZ([UnitsShrinkage])))=0));
--
Arvin Meyer, MCP, MVP
Microsoft Access
Free Access downloads
http://www.datastrat.com
http://www.mvps.org/access

Many thanks

I will copy and paste your solution to construct a query.

Thanks aagain