What is the proper syntax for this operation? I have tried the following: Where tblAssets.AssetName = In ('asset name 1', 'asset name 2', 'asset name 3', 'asset name 4', 'asset name 5') or Where tblAssets.AssetName = In "'asset name 1, 'asset name 2'
Disregard. I found out the problem was that Lansweeper has a very narrow interpretation about what constitutes a comma and a single quote mark. I had been using an html based text editor for doing my script markup. When I switched to Notepad++ and started writing the code out from scratch it worked. One cut/paste and global find and replace later, Viola.
Disregard. I found out the problem was that Lansweeper has a very narrow interpretation about what constitutes a comma and a single quote mark. I had been using an html based text editor for doing my script markup. When I switched to Notepad++ and started writing the code out from scratch it worked. One cut/paste and global find and replace later, Viola.