Search results
-
G
Error: "The expression is typed incorrectly or it is too complex..." on a UNION
Re: Error: "The expression is typed incorrectly or it is too complex..." on a UNION Ah hah! You provided the clue. The price fields are defined as Text. Some prices are numbers (stored as text) wheres other prices are text values "N/A", "Call for quote" or null. I wasn't aware that the... -
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)))...