Здравствуйте ув. Эксперты. Помогите, пожалуйста, с запросом , который я пишу в Delphi 5 к базе mdb (MSAccess). Запрос в приложении. Если пишу без последнего условия, выделенного жирным, то все работает так как нада, но толко допишу z8.dt_modify<=#10/04/2008#, выдает ошибку: Слишком мало параметров. Требуется 1. Заранее спасибо.

Приложение:
SELECT z2.kod_rozp, cod_budj, name, z5.kod_kekv, zaplanovano, ytochneno1, ytochneno2, profinansovano1, profinansovano2, profinansovano3
FROM (((((([select cod_budj, name from TreeBudj where cod_budj LIKE '0230010130%']. AS z1 LEFT JOIN [select kod_rozp, kod_kfk, kod_kekv,sum(m1+m2+m3+m4+m5+m6+m7+m8+m9+m10+m11+m12) as zaplanovano from Plan group by kod_rozp,kod_kfk, kod_kekv]. AS z2 ON z1.cod_budj=z2.kod_rozp) LEFT JOIN [select kod_rozp,unic_code from DocPlan]. AS z3 ON z1.cod_budj=z3.kod_rozp) LEFT JOIN [select m_uniccode, kod_kekv,sum(m1+m2+m3+m4+m5+m6+m7+m8+m9+m10+m11+m12) as ytochneno1 from ModifyPlan group by m_uniccode, kod_kekv]. AS z4 ON z4.m_uniccode=z3.unic_code) LEFT JOIN [select kod_rozp, kod_kfk, kod_kekv,sum(m1+m2+m3+m4+m5+m6+m7+m8+m9+m10+m11+m12) as ytochneno2 from RozpodilPlan group by kod_rozp, kod_kfk, kod_kekv ]. AS z5 ON z1.cod_budj=z5.kod_rozp) LEFT JOIN [select kod_rozp,sum(suma_opl) as profinansovano1 from reestr_d group by kod_rozp]. AS z6 ON z1.cod_budj=z6.kod_rozp) LEFT JOIN [select kod_rozp, sum(suma_opl) as profinansovano2 from RozpodilKoshtReestr group by kod_rozp]. AS z7 ON z1.cod_budj=z7.kod_rozp) LEFT JOIN [select prim_kod_all, sum(summa) as profinansovano3 from Primitka group by prim_kod_all]. AS z8 ON z1.cod_budj=z8.prim_kod_all WHERE (z5.kod_kfk='250380') and (z8.dt_modify<=#10/04/2008#);