ник: OLGA
Посмотрите схему данных.
Вычисление остатка сейчас происходит таким запросом
SELECT Sklad.Kod_List, Sum(Postavki.Kol_P) AS [Sum-Kol_P], Запрос3.SredS, Запрос_RP_Kol.Rasxod, Nz([Sum-Kol_P])-Nz([Rasxod]) AS Ost_S, Nz([Sum-Kol_P],0) AS Приход, Nz([Rasxod],0) AS Расход, (([Приход])-([Расход])) AS Остаток
FROM Sklad LEFT JOIN ((Postavki LEFT JOIN Запрос3 ON Postavki.Kod_P = Запрос3.Kod_P) LEFT JOIN Запрос_RP_Kol ON Запрос3.Name_List = Запрос_RP_Kol.Name_List) ON Sklad.Kod_P = Postavki.Kod_P
GROUP BY Sklad.Kod_List, Запрос3.SredS, Запрос_RP_Kol.Rasxod, Nz([Sum-Kol_P])-Nz([Rasxod]);
Запрос 3
SELECT Postavki.Kod_P, Sum(Postavki.Kol_P) AS [Sum-Kol_P], Sum(Postavki!Kol_P*Postavki!Price) AS Выражение1, ([Выражение1]/[Sum-Kol_P]) AS SredS, Product_List.Name_List
FROM (Product_List INNER JOIN Sklad ON Product_List.Kod_List = Sklad.Kod_List) INNER JOIN Postavki ON Sklad.Kod_P = Postavki.Kod_P
GROUP BY Postavki.Kod_P, Product_List.Name_List;
Запрос_RP_Kol
SELECT Product_List.Name_List, Sum(([Recipes!Kol_Rec]*[R_Products!Kol_RP])) AS Rasxod
FROM Product_List INNER JOIN ((List_R_Products INNER JOIN R_Products ON List_R_Products.Kod_RP = R_Products.Kod_RP) INNER JOIN Recipes ON List_R_Products.Kod_RP = Recipes.Kod_RP) ON Product_List.Kod_List = Recipes.Kod_List
GROUP BY Product_List.Name_List;