AssetName clickable

[harringg]

What modifications are needed to make the resuting tblAssets.AssetName a hyperlink, so I can drill down to the resulting device from the report?

Select Top 1000000 tsysAssetTypes.AssetTypeIcon10 As icon,
  tblAssets.AssetID,
  tblAssets.AssetName As [Device Name],
  tblAssetCustom.Location As [Device Location],
  tblAssets.IPAddress As [IP Address],
  tblAssetCustom.Custom8 As [Switch Location],
  tblAssetCustom.Custom9 As [PatchPanel ID],
  tblAssetCustom.Custom10 As [Switch ID]
From tblAssets
  Inner Join tsysAssetTypes On tsysAssetTypes.AssetType = tblAssets.Assettype
  Left Join tblAssetCustom On tblAssets.AssetID = tblAssetCustom.AssetID
Where tblAssetCustom.Custom9 Like '123%'
Order By tblAssetCustom.Custom10

[Hemoco · Accepted solution]

You need to remove the alias assigned to tblAssets.AssetName.