اخى فى الله بارك الله فيك مشكور هل بالامكان ضبط الكود لكى يعمل على جملة الاستعلام
SELECT qry_Items_Pages_1.iPage, qry_Items_Pages_1.iDate, qry_Items_Pages_1.iName, qry_Items_Pages_1.iBill_Number, qry_Items_Pages_1.[1] AS Store_1, qry_Items_Pages_1.[2] AS Store_2, qry_Items_Pages_1.[3] AS Store_3, qry_Items_Pages_1.[4] AS Store_4, qry_Items_Pages_1.[5] AS Store_5, qry_Items_Pages_1.[6] AS Store_6, qry_Items_Pages_1.[7] AS Store_7
FROM qry_Items_Pages_1
WHERE (((qry_Items_Pages_1.iPage) Between Nz([Forms]![frm_Main]![srch_Page_From_3],0) And Nz([Forms]![frm_Main]![srch_Page_To_3],99999)) AND ((qry_Items_Pages_1.iDate) Between Nz([Forms]![frm_Main]![srch_Date_From_3],#1/1/1900#) And Nz([Forms]![frm_Main]![srch_Date_To_3],#12/30/2100#)));
حيث اننى حاولت الاستفادة من الكود لتصدير ناتج الاستعلام للاكسيل ولم افلح
مشكور اخى فى الله