Inventory Query

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I'm writing a query to calculate inventory by comparing my Product table with
my Sales Orders table. My results only show items with sales activity, but I
want to also see the product names with no sales activity, and their current
quantity.
 
Use a left join Product table with Sales Orders table. In design view drag
their common field from Product table to Sales Orders table field, double
click the connecting line and select all records of Product table.
 
Back
Top