If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Expression Exceeds 1024 character limit of design view, HELP!?
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? |
#2
|
|||
|
|||
Expression Exceeds 1024 character limit of design view, HELP!?
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 * DawnTreader wrote: 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? |
Thread Tools | |
Display Modes | |
|
|