Query Results For items NOT associated with a record

[mo2783]

I have a query which will return the results if a computer has a particular software installed see code

strSQL = "SELECT tbl_Computer_Identification.Computer_Asset_Number, tbl_Computer_Identification.Computer_ID_Make, " & _
    "tbl_Computer_Identification.Computer_ID_Model, tbl_Computer_Identification.Computer_ID_Serial_Number, " & _
    "tbl_Computer_Identification.Computer_ID_Warranty_Expiry, tbl_Computer_Identification.Computer_ID_In_Stock, " & _
    "tbl_Computer_Identification.Computer_ID_Out_Of_Service, [Computer_Main_App_Name] & Chr(32)& [Computer_Main_App_Version] AS Application, " & _
    "tbl_Application_Computer_JoinTable.Computer_ID, tbl_Application_Computer_JoinTable.Application_ID " & _
    "FROM tbl_Computer_Main_Applications INNER JOIN (tbl_Computer_Identification INNER JOIN tbl_Application_Computer_JoinTable ON " & _
    "tbl_Computer_Identification.Computer_ID = tbl_Application_Computer_JoinTable.Computer_ID) ON tbl_Computer_Main_Applications.Computer_Main_Application_ID = " & _
    "tbl_Application_Computer_JoinTable.Application_ID " & _
    "WHERE (((tbl_Computer_Identification.Computer_Asset_Number)= " & Chr(34) & cmbComputerID & Chr(34) & "));"

I need help with Creating a query that will return results of all the software that isnt installed on a particular computer.

Thanks

Mo

 

[PHV]

Observe the SQL code generated by the unmatched query wizard.

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886

 

[mo2783]

SORRY guys

I have 3 tables Holding the following information: -

tbl_Computer_Main_Applications
Computer_Main_Application_ID
Computer_Main_App_Name
Computer_Main_App_Version

tbl_Computer_Identification
Computer_ID
Computer_Asset_Number
Computer_ID_Make
Computer_ID_Model
Computer_ID_Serial_Number
Computer_ID_Warranty_Expiry
Computer_ID_In_Stock
Computer_ID_Out_Of_Service

tbl_Application_Computer_JoinTable
Computer_ID
Application_ID


WHat i am trying to do is create a query which will display all the items in "tbl_Computer_Main_Applications" which are not associated with a particular computer. So all the software that isnt installed on a computer the query should return.

I already have a query which will display all the software computer has installed, see my first post.

Can someone help me as to how i could display the results depending on what software is still available to install?

Thanks

Mo

 

[PHV]

Again, did you try the unmatched query wizard ?

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886

 

[mo2783]

Thanks for the Direction, finally got it working with the Umatched query Wizard.