Custom Report

[Jaycee1964]

Hi,

I need a custom report that shows only the

Computer name
Windows version
Version of Internet Explorer

I can get all but the IE version

Thanks in advance.

John

[RCorbeil · Accepted solution]

Take your existing query and add links to tblSoftware and tblSoftwareUni.

FROM tblAssets
  Inner Join tblSoftware On tblAssets.AssetID = tblSoftware.AssetID
  Inner Join tblSoftwareUni On tblSoftwareUni.SoftID = tblSoftware.softID

and add a filter on the software name to your WHERE clause

Where tblSoftwareUni.softwareName Like 'Windows Internet Explorer%'