how to look null fields in a join query on access?

[Guest]

I have a DB on Access, with 2 tables, one for sell products and other with
problematic products those clients give us back. I want to run a query that
shows me on each month how many sell products and problematics products we
have. But the problem is that the query retrives me only those records that
are in both (sell and problematic) months, so if I sell in January 10 units,
but on the same month I did not have problematics products, the record
doesn't show but I need to show li this:

product sell problematic
123456 10 0

 

[Marshall Barton]

I have a DB on Access, with 2 tables, one for sell products and other with
problematic products those clients give us back. I want to run a query that
shows me on each month how many sell products and problematics products we
have. But the problem is that the query retrives me only those records that
are in both (sell and problematic) months, so if I sell in January 10 units,
but on the same month I did not have problematics products, the record
doesn't show but I need to show li this:

product sell problematic
123456 10 0

You need to use an outer join. In the query's design
window, right click on the line joining the two tables,
select Join Properties from the popup menu and select the
Include all records from the sell table and any matching
records from the problematic table.