Removing a computer type from an all computer report

[feffrey]

I have an all computer report that lists all of our computers. It also picks up our virtual computers for thin clients and lists those. Is there a way I can remove certain rows in the table if the model matches "Virtual Machine"?

[feffrey]

Thank you! That works great.

[Hemoco · Accepted solution]

An example of how to do this can be seen below.

Select tblComputers.Computername, tblComputers.ComputerUnique,
tblComputers.Domain, tblComputersystem.Model
From tblComputers Inner Join
tblComputersystem On tblComputers.Computername =
tblComputersystem.Computername
Where tblComputersystem.Model Not Like '%Virtual Machine%'
Order By tblComputers.ComputerUnique