Populate Field when result is Null

[BarneyH4]

I have two tables: Table #1) [Request Table] Customers request our company to stock a certain Part Number with a minimum value. Ajax - P/N "NP4i" - Min "30".
Table #2) [Sales History] All sales purchased and the "Qty-Total" purchsed. For simplicity Fields are limited.
I created a CrossTab Query that displays from [Request Table] P/N's requested/ min values (Row Headings) then showing P/N's purchased [Sales History] Value="Qty-Total" Sum and Column=Format([Invoice Date],"mmm/yyyy") group by, showing last twelve months.
Ex: Customer name, Part Number, Minimum, May/2013, Apr/2013, Mar/2013 and so on.
AJAX, NP4i, 30 4 21 5 and so on.

The Crosstab query list only requested Part Numbers that have at least One sale wihin the last twelve months.


If there are NO sales, the crosstab query will NOT show this Part Number.
My boss wants to see the requested Part Numbers that were never purchased along with the ones purchased.
He wants to address the NO sales, yet they requested we stock that particular Part Number for them.

Is there any criteria I can use to force the Part Number field on the [Request Table] side to populate even though there were NO sales within the last twelve months?
Thanks, Barney

[June7]

Must include the master parts table in a query that joins with the sales table, join type "show all records from parts ...". Then use that query as the source for the crosstab.

[BarneyH4]

When I do that, the query runs and list 10,333,000 records.
[REQUEST TABLE] has 2,621 records whereas [SalesHistory] Table has 455,563 records.
I am at a loss. Thanks for your help!

[June7]

Cannot include both RequestTable and SalesHistory in the query. You stated requirement was to pivot sales. Why would you include RequestTable? My suggestion was to join Parts with SalesHistory and pivot that. Can also do a query that joins Parts with RequestTable and pivot that.