report build

[praktikants]

so im building this large report and I want to add softwere just microsoft windows and microsoft office so i ned that in report show theire license keys , do i ned a criteria or somethinh else? in report it shows all instaled softwere license keys but i just ned those two

[Hemoco]

try this:

Select tblComputers.Computername, tblComputers.ComputerUnique,
tblComputers.Domain, tblSerialnumber.Product, tblSerialnumber.ProductID,
tblSerialnumber.ProductKey
From tblComputers Inner Join
tblSerialnumber On tblComputers.Computername = tblSerialnumber.Computername
Where (tblSerialnumber.Product Like '%windows%' Or
tblSerialnumber.Product Like '%office%')

[praktikants]

Hello can enyone help me? 😛