Printer usage report

[TonyLC]

I have modified the following report that gives me the information I need

But each printer is listed multiple times in the output

Any help would be appreciated.

Select Top 1000000 tsysAssetTypes.AssetTypeIcon10 As icon,
tblAssets.AssetName,
tblAssetCustom.Model As [Device model],
tblCustDevPrinter.AssetID,
tblAssetCustom.PrintedMonoPages As [Printed Black & White Pages],
tblAssetCustom.PrintedColorPages As [Printed Color Pages],
tblAssetCustom.Printedpages As [Total Printed Pages],
tblAssets.HostTypeId,
tblAssets.IPAddress
From tblCustDevPrinter
Inner Join tblAssets On tblCustDevPrinter.AssetID = tblAssets.AssetID
Inner Join tsysAssetTypes On tblAssets.Assettype = tsysAssetTypes.AssetType
Inner Join tblAssetCustom On tblAssets.AssetID = tblAssetCustom.AssetID

[TonyLC]

That is perfect

Thank You

[brandon_jones · Accepted solution]

Try this instead:

Select Distinct tsysAssetTypes.AssetTypeIcon10 As icon,
  tblAssets.AssetName,
  tblAssetCustom.Model As [Device model],
  tblCustDevPrinter.AssetID,
  tblAssetCustom.PrintedMonoPages As [Printed Black & White Pages],
  tblAssetCustom.PrintedColorPages As [Printed Color Pages],
  tblAssetCustom.Printedpages As [Total Printed Pages],
  tblAssets.HostTypeId,
  tblAssets.IPAddress
From tblCustDevPrinter
  Inner Join tblAssets On tblCustDevPrinter.AssetID = tblAssets.AssetID
  Inner Join tsysAssetTypes On tblAssets.Assettype = tsysAssetTypes.AssetType
  Inner Join tblAssetCustom On tblAssets.AssetID = tblAssetCustom.AssetID