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
الردود الموصى بها
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.