Hi,
I have been working with two tables, MarimbaHWExtractFile & Subnet-Ranges where Site name is updated from table Subnet-Ranges is updated in table MarimbaHWExtractFile at Location field with comparison between IP_Address from MarimbaHWExtractFile and IP Range from Subnet-Ranges.
We are using below code but getting Invalid Procedure Call error. Please help!!
Left([MarimbaHWExtractFile]![IP_Address],(Len([MarimbaHWExtractFile]![IP_Address])-Len(Right([MarimbaHWExtractFile]![IP_Address],Len([MarimbaHWExtractFile]![IP_Address])-InStr(InStr(InStr(1,[MarimbaHWExtractFile]![IP_Address],".")+1,[MarimbaHWExtractFile]![IP_Address],".")+1,[MarimbaHWExtractFile]![IP_Address],"."))))-1)
SQL View - UPDATE MarimbaHWExtractFile, [Subnet-Ranges] SET MarimbaHWExtractFile.Location = [Subnet-Ranges]![Site Name]
WHERE (((Left([MarimbaHWExtractFile]![IP_Address],(Len([MarimbaHWExtractFile]![IP_Address])-Len(Right([MarimbaHWExtractFile]![IP_Address],Len([MarimbaHWExtractFile]![IP_Address])-InStr(InStr(InStr(1,[MarimbaHWExtractFile]![IP_Address],".")+1,[MarimbaHWExtractFile]![IP_Address],".")+1,[MarimbaHWExtractFile]![IP_Address],"."))))-1))=[Subnet-Ranges]![IP Range]));
____
Please see the attached sheet. Thanks