Help with Query

C

CoachBarkerOJPW

I have three tables

tblComputer
ComputerName
Active 1 = acvtivce and not available 0 = inactive and
available

tblApplication
ApplicationName

tblCompAppl
ComputerName
ApplicationName

what I am trying to create is a query that will show the inactive computers
and all the applications on that computer. This is a query to use in a vb.net
form to load the form.

example Query results

CompOne Inactive Word Excel Access FaxEd Visio

Combo Box Check Boxes for the applications
 
Top