SABER_EDP قام بنشر يناير 6, 2016 مشاركة قام بنشر يناير 6, 2016 docmd.RunSQL("INSERT INTO [internal-use]( CUST_TYPE, [total odrer], quantity, [Date] ) SELECT [ALL SALES DATA REPORT].CUST_TYPE, Count([ALL SALES DATA REPORT].CUST_TYPE) AS CountOfCUST_TYPE, Sum([ALL SALES DATA REPORT].TOTAL_QTY_DELIVERED) AS SumOfTOTAL_QTY_DELIVERED, [ALL SALES DATA REPORT].Date FROM [ALL SALES DATA REPORT] GROUP BY [ALL SALES DATA REPORT].CUST_TYPE, [ALL SALES DATA REPORT].Date HAVING ((([ALL SALES DATA REPORT].CUST_TYPE)="Woqod Internal Use (Expenses)") AND (([ALL SALES DATA REPORT].Date)=[Forms]![Main]![dd]));") يظهر خطا عند Woqod رابط هذا التعليق شارك More sharing options...
الردود الموصى بها
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.