SELECT S.Description, S.ProductType, S.[Unit Price], S.MfgPart FROM SHISoftwareImport as S ,Products as P Where S.Description = IIF(InStr(P.ProductName, 1,3) = 'MS', (InStr(P.ProductName,3), P.ProductName))
The error that I get is:
"Syntax error (comma) in query expression 'S.Description = IIF(InStr(P.ProductName, 1,3) = "MS", (InStr(P.ProductName,3), P.ProductName))'.
I swear I've done this before, but since I've been using SQL Server more then Access, I'm a bit rusty on Access syntax. Anyway, can someone help me clear the error, or tell me what I'm doing wrong?
This post has been edited by P4L: 03 June 2011 - 11:29 AM