web40allcompstates.Statename

[MrVal]

I am trying to filter out all Non-Active computers from my reports by using.

web40allcompstates.Statename Not Like 'Non-active'

Problem is that 90% of my PC's have a blank Statename field, dispite having been scanned within the last 24hrs.

Any ideas on why that field is blank for so many PC's?

[MrVal]

Thank you. Worked like a champ.

[Hemoco]

Please use the following report instead:

Select tblComputers.Computername, tblComputers.ComputerUnique,
tblComputers.Domain, web40allcompstates.Thestate, tblstate.Statename
From tblComputers Left Join
web40allcompstates On web40allcompstates.Computername =
tblComputers.Computername Left Join
tblstate On tblstate.State = web40allcompstates.Thestate
Where tblstate.Statename Not Like 'Non-active'
Order By tblComputers.ComputerUnique