→ Having trouble accessing our new support portal or creating a ticket? Please notify our team here

cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
bmbarnett
Engaged Sweeper III
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.
1 ACCEPTED SOLUTION
AZHockeyNut
Champion Sweeper III
off the top of my head try Not in '......'

Where tsysAssetTypes.AssetTypename not in ('Monitor','IOS') and tblState.Statename =
'Active'

something like that?

View solution in original post

2 REPLIES 2
bmbarnett
Engaged Sweeper III
Thank you for your help.
AZHockeyNut
Champion Sweeper III
off the top of my head try Not in '......'

Where tsysAssetTypes.AssetTypename not in ('Monitor','IOS') and tblState.Statename =
'Active'

something like that?