Update Comment Report Syntax

[harringg]

http://lansweeper.com/forum/yaf_postst6963_Custom-report-for-finding-Comments.aspx

I wasn't the OP, but tried to copy/paste the code in the above thread, and there were some typos in it.

The modified code (only change I made was the syntax)

Select Top 1000000 tblAssets.AssetUnique,
  tblAssetComments.AddedBy,
  tblAssetComments.Comment,
  tblAssetComments.Added,
  tblAssets.AssetID
From tblAssets
  Inner Join tblAssetComments On tblAssets.AssetID = tblAssetComments.AssetID
Order By tblAssets.AssetUnique,
  tblAssetComments.AddedBy,
  tblAssetComments.Comment,
  tblAssetComments.Added

Select Top 1000000 tblAssets.AssetID,
  tblAssetDocs.Docname,
  tblAssetDocs.AddedBy,
  tblAssets.AssetUnique,
  tblAssetDocs.Added
From tblAssetDocs
  Inner Join tblAssets On tblAssets.AssetID = tblAssetDocs.AssetID
Order By tblAssetDocs.Docname,
  tblAssetDocs.AddedBy,
  tblAssets.AssetUnique,
  tblAssetDocs.Added