INSERT INTO dbo.tblSPShipInfo_test ( txtINVOICENUM, txtTRACKINGNUM, txtPRONUM, txtSHIPTYPE, dteSHIPDTE, numTRANSCHG, numFUELSURCHG, numOTHCHG, numACCESCHG, numTOTALCHGS, txtSALESORDNUM, txtSENDERNAME, txtSENDERCITY, txtSENDERSTATE, txtSENDERZIP, txtSENDERCTRYREG, txtRECIPNAME, txtRECIPCITY, txtRECIPSTATE, txtRECIPZIP, txtRECIPCTRYREG, numWEIGHT, txtSERVTYPE, txtEXPTYPE, txtRESPFOREXP, txtCOSTCENTER, txtACCOUNTCODE, txtDIVISION )
SELECT INVOICENUM, TRACKINGNUM, PRONUM, IIf([SENDERCITY] ="ROCK HILL" Or [SENDERCITY] ="CHARLOTTE","OUTBOUND","INBOUND") AS SHIPTYPE, SHIPDATE, TRANSCHG, FUELSURCHG, OTHERCHG, ACCESCHG, TOTALCHGS, SALESORDNUM, SENDERNAME, SENDERCITY, SENDERSTATE, SENDERZIP, COUNTRYREGSENDER,RECIPIENTNAME, RECIPIENTCITY, RECIPIENTSTATE, RECIPIENTZIP, COUNTRYREGRECIPIENT, WEIGHT, SERVICETYPE, IIf([COSTCENTER] ="F001","TC","CE") AS EXPTYPE, RESPEXPTYPE, COSTCENTER, ACCOUNTCODE, DIVISION
FROM dbo.tblSP_SHIPMENT_temp;

quote:

---

Originally posted by slimjen

Hi all, Have a MSAccess 2003 frontend and SQL SErver 2008. I am trying to run a pass thru query:

INSERT INTO dbo.tblSPShipInfo_test ( txtINVOICENUM, txtTRACKINGNUM, txtPRONUM, txtSHIPTYPE, dteSHIPDTE, numTRANSCHG, numFUELSURCHG, numOTHCHG, numACCESCHG, numTOTALCHGS, txtSALESORDNUM, txtSENDERNAME, txtSENDERCITY, txtSENDERSTATE, txtSENDERZIP, txtSENDERCTRYREG, txtRECIPNAME, txtRECIPCITY, txtRECIPSTATE, txtRECIPZIP, txtRECIPCTRYREG, numWEIGHT, txtSERVTYPE, txtEXPTYPE, txtRESPFOREXP, txtCOSTCENTER, txtACCOUNTCODE, txtDIVISION )
SELECT INVOICENUM, TRACKINGNUM, PRONUM, IIf([SENDERCITY] ="ROCK HILL" Or [SENDERCITY] ="CHARLOTTE","OUTBOUND","INBOUND") AS SHIPTYPE, SHIPDATE, TRANSCHG, FUELSURCHG, OTHERCHG, ACCESCHG, TOTALCHGS, SALESORDNUM, SENDERNAME, SENDERCITY, SENDERSTATE, SENDERZIP, COUNTRYREGSENDER,RECIPIENTNAME, RECIPIENTCITY, RECIPIENTSTATE, RECIPIENTZIP, COUNTRYREGRECIPIENT, WEIGHT, SERVICETYPE, IIf([COSTCENTER] ="F001","TC","CE") AS EXPTYPE, RESPEXPTYPE, COSTCENTER, ACCOUNTCODE, DIVISION
FROM dbo.tblSP_SHIPMENT_temp;

I get an error:

[Microsoft][ODBC SQL Server Driver][SQL Server]Incorrect syntax near '='
Can someone help me identitfy the problem please. Thks

---