get all active computers

[itdpt]

Hello

I need to have a report where i get a list of all computer with status active .

I've tried with this =

Select tblCompCustom.Computername, tblCompCustom.State
From tblCompCustom Inner Join
tblComputers On tblComputers.Computername = tblCompCustom.Computername
Where tblCompCustom.State = 2

but it did not give me any kind of result.


thank You

Ict dpt

[itdpt]

thank You

got it working !

Cheers

[Hemoco]

try this:

Select tblCompCustom.Computername, tblCompCustom.State
From tblCompCustom Right Join
  tblComputers On tblComputers.Computername = tblCompCustom.Computername
Where tblCompCustom.State = 1