hi all, below is my statement. the below generates all assets and does not provide me with the 90 days. can anyone help advise please.Select Top 1000000 tsysAssetTypes.AssetTypeIcon10 As icon, tblAssets.AssetID, tblAssets.AssetName, tblAssetCustom...