Is there any way to combine these two queries into one? I have tables
Item_Master & Kit_Master which are the source tables. Query 2 is using
both Item_Master (table) & qryKit1 (query) & Kit_Master (table) as its
record source because the Kit_Master table has 2 fields in it that get
joined back to the same field in Item_Master.
Item_Master key field is SKU
Kit_Master key fields are KitNo & ComponentNo
Item_Master - SKU contains a record for each Kit_Master - KitNo and
also for each Kit_Master - ComponentNo
qryKit1:
-----------
SELECT Item_Master.SKU, Item_Master.OnHand
FROM Item_Master
qryKit2:
-----------
SELECT Kit_Master.KitNo, Min(Item_Master.OnHand/[Qty]) AS Availability
FROM (Kit_Master INNER JOIN Item_Master ON Kit_Master.ComponentNo =
Item_Master.SKU) INNER JOIN qryKit1 ON Kit_Master.KitNo = qryKit1.SKU
GROUP BY Kit_Master.KitNo;
I can use two queries if I need to, I was just wondering if it could be
done. Thanks.