Expression Exceeds 1024 character limit of design view, HELP!?

  • Thread starter Thread starter DawnTreader
  • Start date Start date
D

DawnTreader

Hello All

i have a query that goes like this:

SELECT dbo_CUSTOMER_ORDER.CUSTOMER_ID AS CustID, dbo_CUSTOMER.NAME,
dbo_CUSTOMER_ORDER.ID, dbo_CUSTOMER_ORDER.CUSTOMER_PO_REF AS CustPO,
dbo_CUSTOMER_ORDER.ORDER_DATE AS CODate, dbo_CUSTOMER_ORDER.SELL_RATE,
dbo_CUSTOMER_ORDER.CURRENCY_ID, IIf([dbo_CUSTOMER_ORDER]![USER_10] Is
Null,"No Priority",IIf([dbo_CUSTOMER_ORDER]![USER_10]="EMERGENCY MD","Machine
Down",IIf(Left([dbo_CUSTOMER_ORDER]![USER_10],5)="STOCK","Stock",IIf(Left([dbo_CUSTOMER_ORDER]![USER_10],7)="Service","Service",IIf(Left([dbo_CUSTOMER_ORDER]![USER_10],9)="EMERGENCY","Emergency","No
Priority"))))) AS Priority, DateDiff("d",[ORDER_DATE],Now()) AS Age,
dbo_CUSTOMER_ORDER.DESIRED_SHIP_DATE AS DShipDate,
DateDiff("d",Now(),[dbo_CUSTOMER_ORDER].[DESIRED_SHIP_DATE]) AS DaysDue,
dbo_CUSTOMER_ORDER.PROMISE_DATE AS PromDate,
DateDiff("d",Now(),[dbo_CUSTOMER_ORDER].[PROMISE_DATE]) AS PDaysDue,
dbo_CUSTOMER_ORDER.STATUS AS COStatus,
Sum(IIf([TRADE_DISC_PERCENT]>=1,0,IIf([ORDER_QTY]-[TOTAL_SHIPPED_QTY]>0,(([ORDER_QTY]-[TOTAL_SHIPPED_QTY])*IIf([dbo_CUSTOMER_ORDER]![CURRENCY_ID]<>"CDN",[UNIT_PRICE]*[SELL_RATE],[UNIT_PRICE])),0)))
AS OpenValue,
Sum(IIf([TRADE_DISC_PERCENT]>=1,0,IIf([ORDER_QTY]-[TOTAL_SHIPPED_QTY]<=0,([ORDER_QTY]*IIf([dbo_CUSTOMER_ORDER]![CURRENCY_ID]<>"CDN",[UNIT_PRICE]*[SELL_RATE],[UNIT_PRICE])),0)))
AS ClosedValue,
Sum(IIf([TRADE_DISC_PERCENT]>=1,0,[ORDER_QTY]*IIf([dbo_CUSTOMER_ORDER]![CURRENCY_ID]<>"CDN",[UNIT_PRICE]*[SELL_RATE],[UNIT_PRICE])))
AS TotalOrderValue, qryASPOrderTracker.VisualOrderName,
dbo_CUST_ORDER_LINE.GL_REVENUE_ACCT_ID AS GLID,
dbo_CUST_ORDER_LINE.PRODUCT_CODE AS Pcode,
dbo_CUST_ORDER_LINE.TRADE_DISC_PERCENT AS Disc,
IIf([dbo_CUST_ORDER_BINARY].[BITS] Is
Null,"",AlanByteArrayToString([dbo_CUST_ORDER_BINARY]![BITS])) AS OrderSpecs,
IIf([PART_ID] Is Null,IIf([SERVICE_CHARGE_ID] Is Null,False,True),True) AS
ServiceOrder, IIf([dbo_CUSTOMER_ORDER]![USER_10] Is Null,"No
Priority",IIf([dbo_CUSTOMER_ORDER]![USER_10]="EMERGENCY MD","Machine
Down",IIf(Left([dbo_CUSTOMER_ORDER]![USER_10],5)="STOCK","Stock",IIf(Left([dbo_CUSTOMER_ORDER]![USER_10],7)="Service","Service",IIf(Left([dbo_CUSTOMER_ORDER]![USER_10],9)="EMERGENCY","Emergency","No Priority"))))) AS PriorityFilter
FROM qryASPOrderTracker LEFT JOIN (((dbo_CUSTOMER RIGHT JOIN
dbo_CUSTOMER_ORDER ON dbo_CUSTOMER.ID = dbo_CUSTOMER_ORDER.CUSTOMER_ID) LEFT
JOIN dbo_CUST_ORDER_LINE ON dbo_CUSTOMER_ORDER.ID =
dbo_CUST_ORDER_LINE.CUST_ORDER_ID) LEFT JOIN dbo_CUST_ORDER_BINARY ON
dbo_CUSTOMER_ORDER.ID = dbo_CUST_ORDER_BINARY.CUST_ORDER_ID) ON
qryASPOrderTracker.VisualOrderName = dbo_CUSTOMER_ORDER.SALESREP_ID
WHERE
(((Year([ORDER_DATE]))>=IIf([Forms]![frmOrderTracker]![cboFromYear]="All",1900,[Forms]![frmOrderTracker]![cboFromYear]))
AND ((dbo_CUSTOMER_ORDER.STATUS) In
(IIf([Forms]![frmOrderTracker]![tglFirmed]=False,"f",""),IIf([Forms]![frmOrderTracker]![tglReleased]=False,"r",""),IIf([Forms]![frmOrderTracker]![tglOnHold]=False,"h",""),IIf([Forms]![frmOrderTracker]![tglClosed]=False,"c","")))
AND ((qryASPOrderTracker.VisualOrderName)="ATONN" Or
(qryASPOrderTracker.VisualOrderName)="MBAIRD" Or
(qryASPOrderTracker.VisualOrderName)="DGIESBREC" Or
(qryASPOrderTracker.VisualOrderName)="KNERLING") AND
((IIf([dbo_CUSTOMER_ORDER]![USER_10] Is Null,"No
Priority",IIf([dbo_CUSTOMER_ORDER]![USER_10]="EMERGENCY MD","Machine
Down",IIf(Left([dbo_CUSTOMER_ORDER]![USER_10],5)="STOCK","Stock",IIf(Left([dbo_CUSTOMER_ORDER]![USER_10],7)="Service","Service",IIf(Left([dbo_CUSTOMER_ORDER]![USER_10],9)="EMERGENCY","Emergency","No
Priority")))))) In
(IIf([Forms]![frmOrderTracker]![tglStock]=False,"Stock",(IIf([dbo_CUSTOMER_ORDER]![USER_10]
Is Null,"No Priority",IIf([dbo_CUSTOMER_ORDER]![USER_10]="EMERGENCY
MD","Machine
Down",IIf(Left([dbo_CUSTOMER_ORDER]![USER_10],5)="STOCK","Stock",IIf(Left([dbo_CUSTOMER_ORDER]![USER_10],7)="Service","Service",IIf(Left([dbo_CUSTOMER_ORDER]![USER_10],9)="EMERGENCY","Emergency","No
Priority"))))))<>"Stock"),IIf([Forms]![frmOrderTracker]![tglEmergency]=False,"Emergency",(IIf([dbo_CUSTOMER_ORDER]![USER_10]
Is Null,"No Priority",IIf([dbo_CUSTOMER_ORDER]![USER_10]="EMERGENCY
MD","Machine
Down",IIf(Left([dbo_CUSTOMER_ORDER]![USER_10],5)="STOCK","Stock",IIf(Left([dbo_CUSTOMER_ORDER]![USER_10],7)="Service","Service",IIf(Left([dbo_CUSTOMER_ORDER]![USER_10],9)="EMERGENCY","Emergency","No
Priority"))))))<>"Emergency"),IIf([Forms]![frmOrderTracker]![tglMachineDown]=False,"Machine
Down",(IIf([dbo_CUSTOMER_ORDER]![USER_10] Is Null,"No
Priority",IIf([dbo_CUSTOMER_ORDER]![USER_10]="EMERGENCY MD","Machine
Down",IIf(Left([dbo_CUSTOMER_ORDER]![USER_10],5)="STOCK","Stock",IIf(Left([dbo_CUSTOMER_ORDER]![USER_10],7)="Service","Service",IIf(Left([dbo_CUSTOMER_ORDER]![USER_10],9)="EMERGENCY","Emergency","No
Priority"))))))<>"Machine
Down"),IIf([Forms]![frmOrderTracker]![tglService]=False,"Service",(IIf([dbo_CUSTOMER_ORDER]![USER_10]
Is Null,"No Priority",IIf([dbo_CUSTOMER_ORDER]![USER_10]="EMERGENCY
MD","Machine
Down",IIf(Left([dbo_CUSTOMER_ORDER]![USER_10],5)="STOCK","Stock",IIf(Left([dbo_CUSTOMER_ORDER]![USER_10],7)="Service","Service",IIf(Left([dbo_CUSTOMER_ORDER]![USER_10],9)="EMERGENCY","Emergency","No
Priority"))))))<>"Service"),IIf([Forms]![frmOrderTracker]![tglNoPriority]=False,"No
Priority",(IIf([dbo_CUSTOMER_ORDER]![USER_10] Is Null,"No
Priority",IIf([dbo_CUSTOMER_ORDER]![USER_10]="EMERGENCY MD","Machine
Down",IIf(Left([dbo_CUSTOMER_ORDER]![USER_10],5)="STOCK","Stock",IIf(Left([dbo_CUSTOMER_ORDER]![USER_10],7)="Service","Service",IIf(Left([dbo_CUSTOMER_ORDER]![USER_10],9)="EMERGENCY","Emergency","No Priority"))))))<>"No Priority"))))
GROUP BY dbo_CUSTOMER_ORDER.CUSTOMER_ID, dbo_CUSTOMER.NAME,
dbo_CUSTOMER_ORDER.ID, dbo_CUSTOMER_ORDER.CUSTOMER_PO_REF,
dbo_CUSTOMER_ORDER.ORDER_DATE, dbo_CUSTOMER_ORDER.SELL_RATE,
dbo_CUSTOMER_ORDER.CURRENCY_ID, IIf([dbo_CUSTOMER_ORDER]![USER_10] Is
Null,"No Priority",IIf([dbo_CUSTOMER_ORDER]![USER_10]="EMERGENCY MD","Machine
Down",IIf(Left([dbo_CUSTOMER_ORDER]![USER_10],5)="STOCK","Stock",IIf(Left([dbo_CUSTOMER_ORDER]![USER_10],7)="Service","Service",IIf(Left([dbo_CUSTOMER_ORDER]![USER_10],9)="EMERGENCY","Emergency","No
Priority"))))), DateDiff("d",[ORDER_DATE],Now()),
dbo_CUSTOMER_ORDER.DESIRED_SHIP_DATE,
DateDiff("d",Now(),[dbo_CUSTOMER_ORDER].[DESIRED_SHIP_DATE]),
dbo_CUSTOMER_ORDER.PROMISE_DATE,
DateDiff("d",Now(),[dbo_CUSTOMER_ORDER].[PROMISE_DATE]),
dbo_CUSTOMER_ORDER.STATUS, qryASPOrderTracker.VisualOrderName,
dbo_CUST_ORDER_LINE.GL_REVENUE_ACCT_ID, dbo_CUST_ORDER_LINE.PRODUCT_CODE,
dbo_CUST_ORDER_LINE.TRADE_DISC_PERCENT, IIf([dbo_CUST_ORDER_BINARY].[BITS] Is
Null,"",AlanByteArrayToString([dbo_CUST_ORDER_BINARY]![BITS])), IIf([PART_ID]
Is Null,IIf([SERVICE_CHARGE_ID] Is Null,False,True),True),
IIf([dbo_CUSTOMER_ORDER]![USER_10] Is Null,"No
Priority",IIf([dbo_CUSTOMER_ORDER]![USER_10]="EMERGENCY MD","Machine
Down",IIf(Left([dbo_CUSTOMER_ORDER]![USER_10],5)="STOCK","Stock",IIf(Left([dbo_CUSTOMER_ORDER]![USER_10],7)="Service","Service",IIf(Left([dbo_CUSTOMER_ORDER]![USER_10],9)="EMERGENCY","Emergency","No Priority")))))
ORDER BY dbo_CUSTOMER_ORDER.ID DESC;

when i created this in design view i did not type 1024 characters. what is
going on?
 
Hi Dawn,

you can cut the number of characters down by using Aliases
for your source table and query names.

ie:

FROM qryASPOrderTracker AS Q
LEFT JOIN (((dbo_CUSTOMER AS C
RIGHT JOIN dbo_CUSTOMER_ORDER AS CO
ON C.ID = CO.CUSTOMER_ID)
LEFT JOIN dbo_CUST_ORDER_LINE AS CL
ON CO.ID = CL.CUST_ORDER_ID)
LEFT JOIN dbo_CUST_ORDER_BINARY AS CB
ON CO.ID = CB.CUST_ORDER_ID)
ON Q.VisualOrderName = CO.SALESREP_ID

each field reference will also use the short alias instead
of the long tablename

when you are in the design view of the query, you can set
the alias in the Properties window for each fieldlist and
Access will automatically change the SQL


Warm Regards,
Crystal
remote programming and training
http://MSAccessGurus.com

free video tutorials
http://www.YouTube.com/user/LearnAccessByCrystal

Access Basics
http://www.AccessMVP.com/strive4peace
free 100-page book that covers essentials in Access

*
(: have an awesome day :)
*

Hello All

i have a query that goes like this:

SELECT dbo_CUSTOMER_ORDER.CUSTOMER_ID AS CustID, dbo_CUSTOMER.NAME,
dbo_CUSTOMER_ORDER.ID, dbo_CUSTOMER_ORDER.CUSTOMER_PO_REF AS CustPO,
dbo_CUSTOMER_ORDER.ORDER_DATE AS CODate, dbo_CUSTOMER_ORDER.SELL_RATE,
dbo_CUSTOMER_ORDER.CURRENCY_ID, IIf([dbo_CUSTOMER_ORDER]![USER_10] Is
Null,"No Priority",IIf([dbo_CUSTOMER_ORDER]![USER_10]="EMERGENCY MD","Machine
Down",IIf(Left([dbo_CUSTOMER_ORDER]![USER_10],5)="STOCK","Stock",IIf(Left([dbo_CUSTOMER_ORDER]![USER_10],7)="Service","Service",IIf(Left([dbo_CUSTOMER_ORDER]![USER_10],9)="EMERGENCY","Emergency","No
Priority"))))) AS Priority, DateDiff("d",[ORDER_DATE],Now()) AS Age,
dbo_CUSTOMER_ORDER.DESIRED_SHIP_DATE AS DShipDate,
DateDiff("d",Now(),[dbo_CUSTOMER_ORDER].[DESIRED_SHIP_DATE]) AS DaysDue,
dbo_CUSTOMER_ORDER.PROMISE_DATE AS PromDate,
DateDiff("d",Now(),[dbo_CUSTOMER_ORDER].[PROMISE_DATE]) AS PDaysDue,
dbo_CUSTOMER_ORDER.STATUS AS COStatus,
Sum(IIf([TRADE_DISC_PERCENT]>=1,0,IIf([ORDER_QTY]-[TOTAL_SHIPPED_QTY]>0,(([ORDER_QTY]-[TOTAL_SHIPPED_QTY])*IIf([dbo_CUSTOMER_ORDER]![CURRENCY_ID]<>"CDN",[UNIT_PRICE]*[SELL_RATE],[UNIT_PRICE])),0)))
AS OpenValue,
Sum(IIf([TRADE_DISC_PERCENT]>=1,0,IIf([ORDER_QTY]-[TOTAL_SHIPPED_QTY]<=0,([ORDER_QTY]*IIf([dbo_CUSTOMER_ORDER]![CURRENCY_ID]<>"CDN",[UNIT_PRICE]*[SELL_RATE],[UNIT_PRICE])),0)))
AS ClosedValue,
Sum(IIf([TRADE_DISC_PERCENT]>=1,0,[ORDER_QTY]*IIf([dbo_CUSTOMER_ORDER]![CURRENCY_ID]<>"CDN",[UNIT_PRICE]*[SELL_RATE],[UNIT_PRICE])))
AS TotalOrderValue, qryASPOrderTracker.VisualOrderName,
dbo_CUST_ORDER_LINE.GL_REVENUE_ACCT_ID AS GLID,
dbo_CUST_ORDER_LINE.PRODUCT_CODE AS Pcode,
dbo_CUST_ORDER_LINE.TRADE_DISC_PERCENT AS Disc,
IIf([dbo_CUST_ORDER_BINARY].[BITS] Is
Null,"",AlanByteArrayToString([dbo_CUST_ORDER_BINARY]![BITS])) AS OrderSpecs,
IIf([PART_ID] Is Null,IIf([SERVICE_CHARGE_ID] Is Null,False,True),True) AS
ServiceOrder, IIf([dbo_CUSTOMER_ORDER]![USER_10] Is Null,"No
Priority",IIf([dbo_CUSTOMER_ORDER]![USER_10]="EMERGENCY MD","Machine
Down",IIf(Left([dbo_CUSTOMER_ORDER]![USER_10],5)="STOCK","Stock",IIf(Left([dbo_CUSTOMER_ORDER]![USER_10],7)="Service","Service",IIf(Left([dbo_CUSTOMER_ORDER]![USER_10],9)="EMERGENCY","Emergency","No Priority"))))) AS PriorityFilter
FROM qryASPOrderTracker LEFT JOIN (((dbo_CUSTOMER RIGHT JOIN
dbo_CUSTOMER_ORDER ON dbo_CUSTOMER.ID = dbo_CUSTOMER_ORDER.CUSTOMER_ID) LEFT
JOIN dbo_CUST_ORDER_LINE ON dbo_CUSTOMER_ORDER.ID =
dbo_CUST_ORDER_LINE.CUST_ORDER_ID) LEFT JOIN dbo_CUST_ORDER_BINARY ON
dbo_CUSTOMER_ORDER.ID = dbo_CUST_ORDER_BINARY.CUST_ORDER_ID) ON
qryASPOrderTracker.VisualOrderName = dbo_CUSTOMER_ORDER.SALESREP_ID
WHERE
(((Year([ORDER_DATE]))>=IIf([Forms]![frmOrderTracker]![cboFromYear]="All",1900,[Forms]![frmOrderTracker]![cboFromYear]))
AND ((dbo_CUSTOMER_ORDER.STATUS) In
(IIf([Forms]![frmOrderTracker]![tglFirmed]=False,"f",""),IIf([Forms]![frmOrderTracker]![tglReleased]=False,"r",""),IIf([Forms]![frmOrderTracker]![tglOnHold]=False,"h",""),IIf([Forms]![frmOrderTracker]![tglClosed]=False,"c","")))
AND ((qryASPOrderTracker.VisualOrderName)="ATONN" Or
(qryASPOrderTracker.VisualOrderName)="MBAIRD" Or
(qryASPOrderTracker.VisualOrderName)="DGIESBREC" Or
(qryASPOrderTracker.VisualOrderName)="KNERLING") AND
((IIf([dbo_CUSTOMER_ORDER]![USER_10] Is Null,"No
Priority",IIf([dbo_CUSTOMER_ORDER]![USER_10]="EMERGENCY MD","Machine
Down",IIf(Left([dbo_CUSTOMER_ORDER]![USER_10],5)="STOCK","Stock",IIf(Left([dbo_CUSTOMER_ORDER]![USER_10],7)="Service","Service",IIf(Left([dbo_CUSTOMER_ORDER]![USER_10],9)="EMERGENCY","Emergency","No
Priority")))))) In
(IIf([Forms]![frmOrderTracker]![tglStock]=False,"Stock",(IIf([dbo_CUSTOMER_ORDER]![USER_10]
Is Null,"No Priority",IIf([dbo_CUSTOMER_ORDER]![USER_10]="EMERGENCY
MD","Machine
Down",IIf(Left([dbo_CUSTOMER_ORDER]![USER_10],5)="STOCK","Stock",IIf(Left([dbo_CUSTOMER_ORDER]![USER_10],7)="Service","Service",IIf(Left([dbo_CUSTOMER_ORDER]![USER_10],9)="EMERGENCY","Emergency","No
Priority"))))))<>"Stock"),IIf([Forms]![frmOrderTracker]![tglEmergency]=False,"Emergency",(IIf([dbo_CUSTOMER_ORDER]![USER_10]
Is Null,"No Priority",IIf([dbo_CUSTOMER_ORDER]![USER_10]="EMERGENCY
MD","Machine
Down",IIf(Left([dbo_CUSTOMER_ORDER]![USER_10],5)="STOCK","Stock",IIf(Left([dbo_CUSTOMER_ORDER]![USER_10],7)="Service","Service",IIf(Left([dbo_CUSTOMER_ORDER]![USER_10],9)="EMERGENCY","Emergency","No
Priority"))))))<>"Emergency"),IIf([Forms]![frmOrderTracker]![tglMachineDown]=False,"Machine
Down",(IIf([dbo_CUSTOMER_ORDER]![USER_10] Is Null,"No
Priority",IIf([dbo_CUSTOMER_ORDER]![USER_10]="EMERGENCY MD","Machine
Down",IIf(Left([dbo_CUSTOMER_ORDER]![USER_10],5)="STOCK","Stock",IIf(Left([dbo_CUSTOMER_ORDER]![USER_10],7)="Service","Service",IIf(Left([dbo_CUSTOMER_ORDER]![USER_10],9)="EMERGENCY","Emergency","No
Priority"))))))<>"Machine
Down"),IIf([Forms]![frmOrderTracker]![tglService]=False,"Service",(IIf([dbo_CUSTOMER_ORDER]![USER_10]
Is Null,"No Priority",IIf([dbo_CUSTOMER_ORDER]![USER_10]="EMERGENCY
MD","Machine
Down",IIf(Left([dbo_CUSTOMER_ORDER]![USER_10],5)="STOCK","Stock",IIf(Left([dbo_CUSTOMER_ORDER]![USER_10],7)="Service","Service",IIf(Left([dbo_CUSTOMER_ORDER]![USER_10],9)="EMERGENCY","Emergency","No
Priority"))))))<>"Service"),IIf([Forms]![frmOrderTracker]![tglNoPriority]=False,"No
Priority",(IIf([dbo_CUSTOMER_ORDER]![USER_10] Is Null,"No
Priority",IIf([dbo_CUSTOMER_ORDER]![USER_10]="EMERGENCY MD","Machine
Down",IIf(Left([dbo_CUSTOMER_ORDER]![USER_10],5)="STOCK","Stock",IIf(Left([dbo_CUSTOMER_ORDER]![USER_10],7)="Service","Service",IIf(Left([dbo_CUSTOMER_ORDER]![USER_10],9)="EMERGENCY","Emergency","No Priority"))))))<>"No Priority"))))
GROUP BY dbo_CUSTOMER_ORDER.CUSTOMER_ID, dbo_CUSTOMER.NAME,
dbo_CUSTOMER_ORDER.ID, dbo_CUSTOMER_ORDER.CUSTOMER_PO_REF,
dbo_CUSTOMER_ORDER.ORDER_DATE, dbo_CUSTOMER_ORDER.SELL_RATE,
dbo_CUSTOMER_ORDER.CURRENCY_ID, IIf([dbo_CUSTOMER_ORDER]![USER_10] Is
Null,"No Priority",IIf([dbo_CUSTOMER_ORDER]![USER_10]="EMERGENCY MD","Machine
Down",IIf(Left([dbo_CUSTOMER_ORDER]![USER_10],5)="STOCK","Stock",IIf(Left([dbo_CUSTOMER_ORDER]![USER_10],7)="Service","Service",IIf(Left([dbo_CUSTOMER_ORDER]![USER_10],9)="EMERGENCY","Emergency","No
Priority"))))), DateDiff("d",[ORDER_DATE],Now()),
dbo_CUSTOMER_ORDER.DESIRED_SHIP_DATE,
DateDiff("d",Now(),[dbo_CUSTOMER_ORDER].[DESIRED_SHIP_DATE]),
dbo_CUSTOMER_ORDER.PROMISE_DATE,
DateDiff("d",Now(),[dbo_CUSTOMER_ORDER].[PROMISE_DATE]),
dbo_CUSTOMER_ORDER.STATUS, qryASPOrderTracker.VisualOrderName,
dbo_CUST_ORDER_LINE.GL_REVENUE_ACCT_ID, dbo_CUST_ORDER_LINE.PRODUCT_CODE,
dbo_CUST_ORDER_LINE.TRADE_DISC_PERCENT, IIf([dbo_CUST_ORDER_BINARY].[BITS] Is
Null,"",AlanByteArrayToString([dbo_CUST_ORDER_BINARY]![BITS])), IIf([PART_ID]
Is Null,IIf([SERVICE_CHARGE_ID] Is Null,False,True),True),
IIf([dbo_CUSTOMER_ORDER]![USER_10] Is Null,"No
Priority",IIf([dbo_CUSTOMER_ORDER]![USER_10]="EMERGENCY MD","Machine
Down",IIf(Left([dbo_CUSTOMER_ORDER]![USER_10],5)="STOCK","Stock",IIf(Left([dbo_CUSTOMER_ORDER]![USER_10],7)="Service","Service",IIf(Left([dbo_CUSTOMER_ORDER]![USER_10],9)="EMERGENCY","Emergency","No Priority")))))
ORDER BY dbo_CUSTOMER_ORDER.ID DESC;

when i created this in design view i did not type 1024 characters. what is
going on?
Click to expand...
 
Back
Top