For users with multiple workgroups/domains, the current report might show duplicate records if a username exists in more than one domain/workgroup. To avoid this, please change: Left Outer Join tblADusers On tblAssets.Username = tblADusers.Username...