Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I am trying to load this table with a new report
LIB CONNECT TO 'MS Access DB 2.0';
Nuevo:
LOAD "# of Days Late",
"# of Days to Ship",
BackOrder,
Cost,
"Customer Number",
"Date",
GrossSales,
"Invoice Date",
"Invoice Number",
"Item Desc",
"Item Number",
Margin,
"Open Qty",
OpenOrder,
"Order Number",
"Promised Delivery Date",
Sales,
"Sales Qty",
"Sales Rep Number",
SalesKey;
SQL SELECT "# of Days Late",
"# of Days to Ship",
BackOrder,
Cost,
"Customer Number",
"Date",
GrossSales,
"Invoice Date",
"Invoice Number",
"Item Desc",
"Item Number",
Margin,
"Open Qty",
OpenOrder,
"Order Number",
"Promised Delivery Date",
Sales,
"Sales Qty",
"Sales Rep Number",
SalesKey
FROM "C:\USERS\HP\DESKTOP\SCRIPT TUTORIAL\TUTORIALS SOURCE\Sales.accdb"."Sales data";
Tabla:
Load
[Item Desc],
Count([Item Desc]) as ordenclient
Resident Nuevo Group By [Item Desc];
Make sure the data you load into Nuevo isn't automatically added to another table with the exact same fields. Use the NOCONATENATE keyword to prevent automatic concatenation
Nuevo:
NOCONCATENATE LOAD .... etc