New report

[Cobra7]

Ok, have a report almost done. It finds all of the information I want but just need to filter a result.

SELECT TOP 100 PERCENT 
  tblComputers.Computername,
  tblComputers.Username,
  tblRegistry.Value,
  tblSoftware.softwareName,
  tblRegistry.Regkey
FROM
  tblComputers
  INNER JOIN tblRegistry ON (tblComputers.Computername = tblRegistry.Computername)
  INNER JOIN tblSoftware ON (tblRegistry.Computername = tblSoftware.ComputerName)
WHERE
  tblSoftware.softwareName = 'Catalyst WMS Client' AND 
  tblRegistry.Regkey = 'HKEY_LOCAL_MACHINE\SOFTWARE\WMS\WMS 011310' AND 
  tblRegistry.Value IS NOT NULL

Pretty much I displau tblRegistry.RegKey, but I would like to cut off the earlier sections and display only WMS 011310. Is there a way to do that or will I need to add another registry key?

[Hemoco · Accepted solution]

Don't know the exact result you want, but you can try this:

Select Top 1000000 tblComputers.Computername, tblComputers.Username,
  tblRegistry.Value, tblSoftware.softwareName, tblRegistry.Regkey
From tblComputers Inner Join
  tblRegistry On (tblComputers.Computername = tblRegistry.Computername)
  Inner Join
  tblSoftware On tblSoftware.ComputerName = tblComputers.Computername
Where tblRegistry.Value Is Not Null And tblSoftware.softwareName =
  'Catalyst WMS Client' And
  tblRegistry.Regkey = 'HKEY_LOCAL_MACHINE\SOFTWARE\WMS\WMS 011310'