Multiple instances of the same asset with different fields

[mbjhug]

Select Top 1000000 tblAssetCustom.Manufacturer,
  tblAssetCustom.Model,
  tblAssetCustom.PurchaseDate,
  tblAssetCustom.Warrantydate,
  tblAssets.AssetID,
  tblAssets.AssetUnique,
  tblAssets.Memory,
  tblDiskdrives.FileSystem,
  tblDiskdrives.Freespace,
  tblDiskdrives.Size,
  tsysOS.OSname,
  tsysOS.OScode As icon,
  tblProcessor.Name
From tblAssetCustom
  Inner Join tblAssets On tblAssets.AssetID = tblAssetCustom.AssetID
  Inner Join tblDiskdrives On tblAssets.AssetID = tblDiskdrives.AssetID
  Inner Join tblProcessor On tblAssets.AssetID = tblProcessor.AssetID,
  tsysOS

I'm trying to create a report for brand, model, processor, OS, memory, disk size, disk used, and age of device. When I run the report, there are multiple lines with same asset, but with different OS names for each line, all of which are repeated several times, then the entire chunk for that asset is displayed again, but without the file system or free space.

I'm very new to this so any help would be greatly appreciated!

[Hemoco · Accepted solution]

You haven't linked tsysOS to anything. Please try the report below instead.

Select Top 1000000 tblAssetCustom.Manufacturer,
tblAssetCustom.Model,
tblAssetCustom.PurchaseDate,
tblAssetCustom.Warrantydate,
tblAssets.AssetID,
tblAssets.AssetUnique,
tblAssets.Memory,
tblDiskdrives.FileSystem,
tblDiskdrives.Freespace,
tblDiskdrives.Size,
tsysOS.OSname,
tsysOS.OScode As icon,
tblProcessor.Name
From tblAssetCustom
Inner Join tblAssets On tblAssets.AssetID = tblAssetCustom.AssetID
Inner Join tblDiskdrives On tblAssets.AssetID = tblDiskdrives.AssetID
Inner Join tblProcessor On tblAssets.AssetID = tblProcessor.AssetID
inner join tsysOS on tblAssets.OScode = tsysOS.OScode