We ended up using this statement and it worked for us.tblDiskdrives.Caption LIKE 'C:'Just add it inside your where statement. See below for reference. Select Top 1000000 tblAssets.AssetID, tblAssets.AssetName, tblAssets.Domain, tblAssets.Username,...