Всем добрый день подскажите в чём ошибка
есть 3 запроса и 4-ый запрос на объединение этих 3-х

запрос1:SELECT "1.Остаток на начало дня" AS oper, "" AS ДАТА, "" AS Firma, "" AS podrazdelenie, "" AS who, "" AS kategoriya, "" AS Prim, Sum(IIf([date_oper]>#4/30/2004#,IIf([Prih/Rash] Like "РАСХОД",-[Sum_rub],[Sum_rub]))) AS RUB, Sum(IIf([date_oper]>#4/30/2004#,IIf([Prih/Rash] Like "РАСХОД",-[Sum_eur],[Sum_eur]))) AS EUR, Sum(IIf([date_oper]>#4/30/2004#,IIf([Prih/Rash] Like "РАСХОД",-[Sum_usd],[Sum_usd]))) AS USD
FROM Rashod_oksana
WHERE (((Rashod_oksana.del)=No) AND ((Rashod_oksana.Date_oper)<[Forms]![Форма1]![date]))
GROUP BY "";

Запрос 2:SELECT IIf([Prih/Rash] Like "ПРИХОД","2.ПРИХОД","2.РАСХОД") AS oper, Rashod_oksana.date AS ДАТА, Rashod_oksana.Firma, Rashod_oksana.podrazdelenie, Rashod_oksana.who, Rashod_oksana.kategoriya, Rashod_oksana.Prim, Rashod_oksana.Sum_rub, Rashod_oksana.Sum_eur, Rashod_oksana.Sum_usd
FROM Rashod_oksana
WHERE (((Rashod_oksana.Date_oper)=[Forms]![Форма1]![date]) AND ((Rashod_oksana.del)=No))
ORDER BY IIf([Prih/Rash] Like "ПРИХОД","2.ПРИХОД","2.РАСХОД"), Rashod_oksana.Firma, Rashod_oksana.podrazdelenie, Rashod_oksana.Date_oper
WITH OWNERACCESS OPTION;

запрос 3:SELECT "3.Остаток на конец дня" AS oper, "" AS ДАТА, "" AS Firma, "" AS podrazdelenie, "" AS who, "" AS kategoriya, "" AS Prim, Sum(IIf([date_oper]>#4/30/2004#,IIf([Prih/Rash] Like "РАСХОД",-[Sum_rub],[Sum_rub]))) AS RUB, Sum(IIf([date_oper]>#4/30/2004#,IIf([Prih/Rash] Like "РАСХОД",-[Sum_eur],[Sum_eur]))) AS EUR, Sum(IIf([date_oper]>#4/30/2004#,IIf([Prih/Rash] Like "РАСХОД",-[Sum_usd],[Sum_usd]))) AS USD
FROM Rashod_oksana
WHERE (((Rashod_oksana.del)=No) AND ((Rashod_oksana.Date_oper)<=[Forms]![Форма1]![date]))
GROUP BY "";

Запрос 4:SELECT ost_start.*
FROM ost_start
UNION SELECT Ost_reestr.*
FROM Ost_reestr WITH OWNERACCESS OPTION
UNION SELECT ost_finish.*
FROM ost_finish;

Поотдельности все запросы работатют правильно, а в запросе 4 данные которые из запроса 2 неправильные, не хватает нескольких строк. Что это может быть?

Спасибо

ok спасибо не знал