Search results

  1. G

    Error: "The expression is typed incorrectly or it is too complex..." on a UNION

    Error: "The expression is typed incorrectly or it is too complex..." on a UNION I have a query: SELECT 'NA_List_Price' AS PriceList, prices.ModelNumber, IIf(prices.NA_List_Price is Null,-1,IIf(prices.NA_List_Price = "N/A",-2,IIF(Left(prices.NA_List_Price,4)="Call",-3,prices.NA_List_Price)))...
Back
Top Bottom