I share my little sheet. Welcome to make it better. To work it had to be with SQL server, not compact version. LinkSelect Distinct Top 1000000 tblAssets.AssetID, tblAssets.AssetName, Case When (tblAssetCustom.State Like '1') Then 'Active' When (...
I think that I start copy and paste with this report. At the end I have this.A 'Case' to change every not lucky name manufacturer from Lansweeper to his real name, if you have holes maybe you have to made a new 'When'.The Size is meticulous hand work...