return all dataset with null records

[Guest]

Thank you in advance for your help.

My query returns:
Products Qty. Sold
Product A 5
Product C 7

What I want is to include all products sold even with zero quantity as
follows.
Product A 5
Product B 0
Product C 7

Thanks
Jay

 

[Guest]

Show us the SQL. Open the query in design view. Next go to View, SQL View
and copy and past it here.

 

[pietlinden]

Thank you in advance for your help.

My query returns:
Products Qty. Sold
Product A 5
Product C 7

What I want is to include all products sold even with zero quantity as
follows.
Product A 5
Product B 0
Product C 7

Thanks
Jay

Left join Products to SalesLineItems, then maybe use NZ to convert the
null to a zero, because you can't do math on a null.