Query when no records

  • Thread starter Thread starter Lasse T
  • Start date Start date
L

Lasse T

Hello.
I hope someone can help me with this.
I´m experiencing some problems trying to calculate stock. I make a query
based on the items table, the order table and the table for incoming items.
The query only shows records if the item exists in all three tables. This I
can understand but I don´t know how to get around it. How can I make a query
that shows all of the items from the items table? Or am I on the wrong track
here?

Lasse T
------------
 
I think you have to paste the actually query to see what you are doing. Joins,
Unions, intersects, select, subqueries, etc.
(e-mail address removed)
 
Use Left Join from the tblItem to the other 2 Tables
tblOrder and tblIncomingItems. You probably will need to
use the Nz() function in the calculation to convert from
Null to zero.

Check Access / JET help on Left Join & Nz() function.

HTH
Van T. Dinh
MVP (Access)
 
Thank you very much. That took me a big step forward, but a new problem
showed up. I´ll start a new thread on that.
(subject: Stock list)
Lasse T
--------------

"Van T. Dinh" <[email protected]> skrev i meddelandet
Use Left Join from the tblItem to the other 2 Tables
tblOrder and tblIncomingItems. You probably will need to
use the Nz() function in the calculation to convert from
Null to zero.

Check Access / JET help on Left Join & Nz() function.

HTH
Van T. Dinh
MVP (Access)
 
Back
Top