return all dataset with null records

J

Jay

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
 
J

Jerry Whittle

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

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
Click to expand...

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.
 
Top