Want Assets only if Custom6 field has data

[harringg]

I'm trying to build a phone list using the actual telephone as an Asset (so I can also track the hardware for warranty issues).

tblAssetCustom.Custom6 contains a phone number. I only want a report that will return values if it's got a number (ie IS NOT NULL).

The first report is what I'm trying, but LS v6051 keeps reverting the second report and lists all active assets, regardless if they have a value in Custom6 or not.

I know I can modify my Where to only grab certain Asset Types, but I'd like to keep the report small.

Select Top 1000000 tblAssets.AssetID,
  tblAssets.AssetName,
  tsysAssetTypes.AssetTypeIcon10 As icon,
  tblAssetCustom.Custom4 As Description,
  tblAssetCustom.Department,
  tblAssetCustom.Custom6 As Extension,
  tblAssetCustom.Location
From tblAssets
  Inner Join tblAssetCustom On tblAssets.AssetID = tblAssetCustom.AssetID
  Inner Join tsysAssetTypes On tsysAssetTypes.AssetType = tblAssets.Assettype
Where ((tblAssetCustom.Custom6 Is Not Null) And (tblAssetCustom.State = 1))

Select Top 1000000 tblAssets.AssetID,
  tblAssets.AssetName,
  tsysAssetTypes.AssetTypeIcon10 As icon,
  tblAssetCustom.Custom4 As Description,
  tblAssetCustom.Department,
  tblAssetCustom.Custom6 As Extension,
  tblAssetCustom.Location
From tblAssets
  Inner Join tblAssetCustom On tblAssets.AssetID = tblAssetCustom.AssetID
  Inner Join tsysAssetTypes On tsysAssetTypes.AssetType = tblAssets.Assettype
Where tblAssetCustom.Custom6 Is Not Null And tblAssetCustom.State = 1