Show assets with last comment

[barteks]

Hi,
I created a report which shows servers with some information, but when one of them have more than 1 comment it shows the entry several times.
Can someone help me edit report to show only one entry with last comment?

Select Top 1000000 tsysOS.Image As icon,
  tblAssets.AssetID,
  tblAssets.AssetName,
  tblAssets.Domain,
  tblAssets.Username,
  tblAssets.IPAddress,
  tblAssetCustom.Manufacturer,
  tblAssetCustom.Model,
  tsysIPLocations.IPLocation,
  tsysOS.OSname As OS,
  tblAssetCustom.PurchaseDate,
  tblAssetCustom.Warrantydate,
  tblAssets.Lastseen,
  tblAssetCustom.Serialnumber,
  tblAssetComments.Comment,
  tblAssetComments.Added
From tblAssets
  Inner Join tblComputersystem On tblAssets.AssetID = tblComputersystem.AssetID
  Inner Join tsysOS On tblAssets.OScode = tsysOS.OScode
  Inner Join tblAssetCustom On tblAssets.AssetID = tblAssetCustom.AssetID
  Left Join tsysIPLocations On tsysIPLocations.StartIP <= tblAssets.IPNumeric
      And tsysIPLocations.EndIP >= tblAssets.IPNumeric
  Left Join tblAssetComments On tblAssets.AssetID = tblAssetComments.AssetID
Where tblAssets.AssetName Like 'c%' And (tblAssetCustom.Manufacturer = 'IBM' Or
    tblAssetCustom.Manufacturer = 'FUJITSU' Or tblAssetCustom.Manufacturer =
    'Dell Inc.') And tblComputersystem.Domainrole > 1 And tblAssetCustom.State =
  1 And tblComputersystem.SystemType Like 'x64%'
Order By tblAssets.AssetName