I have a data table containing a list of orders for parts to be
manufactured. There can be several orders for the same part logged into this
table, along with several orders for each and every other part produced.
Manufacturing can never complete an entire order without having to
switch to another version to keep up with demand, so I have created another
table in which I have logged in partial order completions. The partial
completions table will only have a small percentage of the entire product
line logged in at any one time.
I have created a query that groups like products together for Sum of
quantities.
I have another query in which I do the same for the partial orders
table.
I want to create another query in which I subtract the sums of
tblPartialFills from tblOrders if the products match (3 description fields
have to match), but I also want to show the order totals which do not have a
match in the partial fills table. This is what I have not been able to do.
This is a personal project that I have set myself as a learning
experience (I'm taking Intro to MS Access this semester). I have learned
alot, but now I've hit a stone wall.
Can anyone see a solution to this?

Thanks -


--

/ Sean the Mc /


"I have not failed. I've just found 10,000 ways that won't work."
- Thomas Alva Edison (1847-1931)