SELECT Bill_arrival.[Реф №], Bill_arrival.Наименование, Bill_arrival.Дата1, Bill_arrival.Дата2, round(Bill_arrival.Эквивалент1,  2 ) AS [КА+ 1 ], round(Bill_arrival.Эквивалент2,  2 ) AS [КА- 1 ],  "" AS [От А+1 ], " " AS [От А-1 ], " " AS [K+1 ], " " AS [K-1 ], " " AS [Б+1 ], " " AS [Б-1 ], " " AS [62 + 1 ], " " AS [62 - 1 ], " " AS [61 + 1 ], " " AS [61 - 1 ], " " AS [T+1 ], " " AS [T-1 ], " " AS [Рз+1 ], " " AS [Рз-1 ]
FROM Bill_arrival
WHERE (((Bill_arrival.[Реф №])=[forms]![заказ]![ref]))
UNION ALL
SELECT Bill_charge.[Реф №], Bill_charge.Наименование, Bill_charge.Дата1, Bill_charge.Дата2, " " AS [КА+1 ], " " AS [КА-1 ], round(Bill_charge.Эквивалент1,  2 ) AS [От А+ 1 ],round(Bill_charge.Эквивалент2,  2 ) AS [От А- 1 ], " " AS [K+1 ], " " AS [K-1 ], " " AS [Б+1 ], " " AS [Б-1 ], " " AS [62 + 1 ], " " AS [62 - 1 ], " " AS [61 + 1 ], " " AS [61 - 1 ], " " AS [T+1 ], " " AS [T-1 ], " " AS [Рз+1 ], " " AS [Рз-1 ]
FROM Bill_charge
WHERE (((Bill_charge.[Реф №])=[forms]![заказ]![ref]))
UNION ALL
SELECT Cash.[Реф №], Cash.Наименование, Cash.Дата, " " AS дата2, "  " AS [КА+1 ], " " AS [КА-1 ], " " AS [От А+1 ], " " AS [От А-1 ], round(Cash.Эквивалент1,  2 ) AS [K+ 1 ], round(Cash.Эквивалент2,  2 ) AS [K- 1 ], " " AS [Б+1 ], " " AS [Б-1 ], " " AS [62 + 1 ], " " AS [62 - 1 ], " " AS [61 + 1 ], " " AS [61 - 1 ], " " AS [T+1 ], " " AS [T-1 ], " " AS [Рз+1 ], " " AS [Рз-1 ]
FROM Cash
WHERE (((Cash.[Реф №])=[forms]![заказ]![ref]))
UNION ALL
SELECT Bank.[Реф №], Bank.Наименование, Bank.Дата1, Bank.Дата2, " " AS [КА+1 ], " " AS [КА-1 ], " " AS [От А+1 ], " " AS [От А-1 ], " " AS [K+1 ], " " AS [K-1 ], round(Bank.Эквивалент1,  2 ) AS [Б+ 1 ], round(Bank.Эквивалент2,  2 ) AS [Б- 1 ], " " AS [62 + 1 ], " " AS [62 - 1 ], " " AS [61 + 1 ], " " AS [61 - 1 ], " " AS [T+1 ], " " AS [T-1 ], " " AS [Рз+1 ], " " AS [Рз-1 ]
FROM Bank
WHERE (((Bank.[Реф №])=[forms]![заказ]![ref]))
UNION ALL
SELECT Зад_потр.[Реф №], Зад_потр.Наименование, Зад_потр.Дата1, Зад_потр.Дата2, " " AS [КА+1 ], " " AS [КА-1 ], " " AS [От А+1 ], " " AS [От А-1 ], " " AS [K+1 ], " " AS [K-1 ], " " AS [Б+1 ], " " AS [Б-1 ], round(Зад_потр.Эквивалент1,  2 ) AS [ 62 + 1 ], round(Зад_потр.Эквивалент2,  2 ) AS [ 62 - 1 ], " " AS [61 + 1 ], " " AS [61 - 1 ], " " AS [T+1 ], " " AS [T-1 ], " " AS [Рз+1 ], " " AS [Рз-1 ]
FROM Зад_потр
WHERE (((Зад_потр.[Реф №])=[forms]![заказ]![ref]))
UNION ALL
SELECT Зад_пост.[Реф №], Зад_пост.Наименование, Зад_пост.Дата1, Зад_пост.Дата2, " " AS [КА+1 ], " " AS [КА-1 ], " " AS [От А+1 ], " " AS [От А-1 ], " " AS [K+1 ], " " AS [K-1 ], " " AS [Б+1 ], " " AS [Б-1 ], " " AS [62 + 1 ], " " AS [62 - 1 ], round(Зад_пост.Эквивалент1,  2 ) AS [ 61 + 1 ], round(Зад_пост.Эквивалент2,  2 ) AS [ 61 - 1 ], " " AS [T+1 ], " " AS [T-1 ], " " AS [Рз+1 ], " " AS [Рз-1 ]
FROM Зад_пост
WHERE (((Зад_пост.[Реф №])=[forms]![заказ]![ref]))
UNION ALL
SELECT sklad.[Реф №], sklad.Наименование, sklad.Дата1, sklad.Дата2, " " AS [КА+1 ], " " AS [КА-1 ], " " AS [От А+1 ], " " AS [От А-1 ], " " AS [K+1 ], " " AS [K-1 ], " " AS [Б+1 ], " " AS [Б-1 ], " " AS [62 + 1 ], " " AS [62 - 1 ], " " AS [61 + 1 ], " " AS [61 - 1 ], round(sklad.Эквивалент1,  2 ) AS [T+ 1 ], round(sklad.Эквивалент2,  2 ) AS [T- 1 ], " " AS [Рз+1 ], " " AS [Рз-1 ]
FROM sklad
WHERE (((sklad.[Реф №])=[forms]![заказ]![ref]))
UNION ALL SELECT Realization.[Реф №], Realization.Наименование, Realization.Дата1, Realization.Дата2, " " AS [КА+1 ], " " AS [КА-1 ], " " AS [От А+1 ], " " AS [От А-1 ], " " AS [K+1 ], " " AS [K-1 ], " " AS [Б+1 ], " " AS [Б-1 ], " " AS [62 + 1 ], " " AS [62 - 1 ], " " AS [61 + 1 ], " " AS [61 - 1 ], " " AS [T+1 ], "" AS [T- 1 ], round(Realization.Эквивалент1,  2 ) AS [Рз+ 1 ], round(Realization.Эквивалент2,  2 ) AS [Рз- 1 ]
FROM Realization
WHERE (((Realization.[Реф №])=[forms]![заказ]![ref]));

SELECT  "Авансы будущих периодов"  As Наименование , Sum(IIf([ 62 +]= "",0 ,[ 62 +])) - Sum(IIf([ 62 -]=" ",0 ,[ 62 -])) AS [Сумма]
FROM проводки_1
UNION ALL
SELECT "Задолженность клиента " As Наименование , Sum(IIf([КА+]="  ",0 ,[КА+])) - Sum(IIf([КА-]=" ",0 ,[КА-])) AS [Сумма]
FROM проводки_1
UNION ALL
SELECT "Товар на складе " As Наименование , Sum(IIf([T+]="  ",0 ,[T+])) - Sum(IIf([T-]=" ",0 ,[T-])) AS [Сумма]
FROM проводки_1
UNION ALL
SELECT "Плановые платежи " As Наименование , Sum(IIf([От А-]="  ",0 ,[От А-])) - Sum(IIf([От А+]=" ",0 ,[От А+])) AS [Сумма]
FROM проводки_1
UNION ALL
SELECT "Себестоимость " As Наименование , (Sum(IIf([61 +]=" ",0 ,[ 61 +])) - Sum(IIf([ 61 -]=" ",0 ,[ 61 -]))) + (Sum(IIf([T+]=" ",0 ,[T+])) - Sum(IIf([T-]=" ",0 ,[T-]))) + (Sum(IIf([От А-]=" ",0 ,[От А-])) - Sum(IIf([От А+]=" ",0 ,[От А+]))) AS [Сумма]
FROM проводки_1
UNION ALL
SELECT "Плановый доход " As Наименование , Sum(IIf([КА+]="  ",0 ,[КА+])) - Sum(IIf([От А-]=" ",0 ,[От А-])) AS [Сумма]
FROM проводки_1
UNION ALL SELECT "Реальный доход " As Наименование , Sum(IIf([Рз-]="  ",0 ,[Рз-])) - Sum(IIf([Рз+]="", 0 ,[Рз+])) AS [Сумма]
FROM проводки_1;

SELECT  "Авансы будущих периодов"  As Наименование , 
Sum(IIf(round(Зад_потр.Эквивалент1,  2 )= "",0 ,round(Зад_потр.Эквивалент1, 
 2 ))) - Sum(IIf(round(Зад_потр.Эквивалент2,  2 )="", 0 ,round(Зад_потр.Эквивалент2,  2 ))) AS [Сумма]
FROM Зад_потр
WHERE (((Зад_потр.[Реф №])=[forms]![заказ]![ref]))

SELECT  "Авансы будущих периодов"  AS Наименование, 
Sum(IIf(round([Зад_потр].[Эквивалент1], 2 )= "",0 ,round([Зад_потр].[Эквивалент1], 2 )))
-Sum(IIf(round([Зад_потр].[Эквивалент2], 2 )="", 0 ,round([Зад_потр].[Эквивалент2], 2 ))) AS Сумма
FROM Зад_потр
WHERE ((([Зад_потр].[Реф №])=[forms]![заказ]![ref]));

SELECT  "Авансы будущих периодов"  AS Наименование, 
Sum(NZ(round([Зад_потр].[Эквивалент1], 2 ), 0 )) 
-Sum(NZ(round([Зад_потр].[Эквивалент2], 2 ), 0 )) AS Сумма
FROM Зад_потр
WHERE ((([Зад_потр].[Реф №])=[forms]![заказ]![ref]));