Try building your query/report to select the Comment field from the dbo.InvHist_Comment table.

For example:

Select HIS.[Comment]

from VAsset VA

left outer join dbo.InvHist_Comment HIS on HIS.[_ResourceGUID] = va.[_Resourceguid]

where HIS.[Comment] like 'specific word'

Hope this helps...

Why query the history data while all he wants is the current value?

I would use:

Select HIS.[Comment]

from VAsset VA

left outer join dbo.Inv_Comment cmt on cmt.[_ResourceGUID] = va.[_Resourceguid]

where cmt.[Comment] like 'specific word'

I strongly agree with MagicGuru...

I didn't see anything about only wanting the "current value" in  yusab's request, so I grabbed the table name from a report that was showing all Comments just to to use as an example.
If using the dbo.Inv_Comment works better, cool. Only thing is, the example above won't work without changing the select statement to Select CMT.[Comment]