please translate the following report to the new format.
source: http://www.lansweeper.com/kb/19/report-based-on-file-information.html
Select tblComputers.Computername, tblComputers.ComputerUnique, tblFileVersions.FilePathfull, tblFileVersions.Found,
tblFileVersions.FileVersion, tblFileVersions.CompanyName, tblFileVersions.Filesize
From tblComputers Inner Join tblFileVersions On tblComputers.Computername = tblFileVersions.Computername
Where tblFileVersions.FilePathfull Like '%firefox.exe'
many thanks!
pete