
Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎02-23-2018 09:02 PM
When I exclude one the code is
Where tsysAssetTypes.AssetTypename != 'Monitor' And tblState.Statename =
'Active'
Order By AssetType,
tblAssets.AssetName
And it excludes Monitor
But when I add another one more to the Or.. it looks like
Where (tsysAssetTypes.AssetTypename != 'Monitor' And tblState.Statename =
'Active') Or
(tsysAssetTypes.AssetTypename != 'IOS')
It doesn't exclude anything with the code above.
Where tsysAssetTypes.AssetTypename != 'Monitor' And tblState.Statename =
'Active'
Order By AssetType,
tblAssets.AssetName
And it excludes Monitor
But when I add another one more to the Or.. it looks like
Where (tsysAssetTypes.AssetTypename != 'Monitor' And tblState.Statename =
'Active') Or
(tsysAssetTypes.AssetTypename != 'IOS')
It doesn't exclude anything with the code above.
Solved! Go to Solution.
Labels:
- Labels:
-
Report Center
1 ACCEPTED SOLUTION

Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎02-26-2018 04:13 PM
off the top of my head try Not in '......'
Where tsysAssetTypes.AssetTypename not in ('Monitor','IOS') and tblState.Statename =
'Active'
something like that?
Where tsysAssetTypes.AssetTypename not in ('Monitor','IOS') and tblState.Statename =
'Active'
something like that?
2 REPLIES 2

Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎03-05-2018 10:43 PM
Thank you for your help.

Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎02-26-2018 04:13 PM
off the top of my head try Not in '......'
Where tsysAssetTypes.AssetTypename not in ('Monitor','IOS') and tblState.Statename =
'Active'
something like that?
Where tsysAssetTypes.AssetTypename not in ('Monitor','IOS') and tblState.Statename =
'Active'
something like that?
