Hello ChrisnLBC, I can provide adhoc reporting development for you. We can discuss further offline. You can contact me with the email on my profile. You can also check out some of my answers here on the forum. Regards,Endy
Hello Dan,I think this should do it for you. SELECT tbladusers.username, tblAssetUserRelations.AssetID, tblassets.AssettypeFROM tblADusersINNER JOIN tblassetuserrelations ON tbladusers.username=tblassetuserrelations.usernameINNER JOIN tbl...
Hello,I found one that I slightly modified. Hope it helps.Select Top 1000000 Case When tblComputersystem.Domainrole > 1 Then 'Server' Else Case When Coalesce(tblPortableBattery.AssetID, 0) = 0 The...