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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Check Box query issue 3
Searching for specific word in query 3
Query based on Check boxes 2
Datasheet combo box empty 1
Error in Delete Query 6
Unable to set query parameter 17
Adding Query Design Grid columns in Access 2007 1
Varying cell ranges in formulas according to number of cells with certain value 1

Top