I Have 2 tables.

tblOrders contains all open and closed orders:

Product - Part - Part Variant - Quantity of Order

tblPartialCompletions contains a record of how many of these orders have
been completed in the manufacturing process to date, and contains all the
same data as tblOrders.
(I know, not very efficient - this is my first learning experience, and
anyone who knows Access would probably cringe to see this DB)

At any given time, there will be only a small percentage of the total
product line that actually has a partially completed order in
tblPartialCompletions.

I want to create a query that will subtract the partial quantity produced to
date from the total amount ordered for this particular product, but will
also show all other order quantity totals that don't have partial
completions subtracted. (Therein lies my problem - I can show the adjusted
quantities in a query, but all non adjusted order quantities are filtered
out because they have no matching item in tblPartialCompletions.

Can this be done?
- Thanks - Sean