I need help with creating a nested select statement. I have 2 tables shown below (they contain more fields, but am only listing what is applicable:
Requirements Table
U_RQ_ID
U_RQ_Description
U_Applicable Configurations Table
U_RQ_ID
U_Vehicle_Config_ID
I have a list box that the user will select a vehicle configuration ID and want to be able to pull up all the requirements for that vehicle configuration ID. A requirement can be applicable to several vehicle configurations.
Here is the select statement I am having trouble with. The error I am receiving is: Too few parameters: Expected 2.
Set rst = db.OpenRecordset("Select * from U_requirements where U_requirements.[U_RQ_ID] IN (Select U_Applicable_Configs.[U_RQ
Thank you!
Chaticathe
Requirements Table
U_RQ_ID
U_RQ_Description
U_Applicable Configurations Table
U_RQ_ID
U_Vehicle_Config_ID
I have a list box that the user will select a vehicle configuration ID and want to be able to pull up all the requirements for that vehicle configuration ID. A requirement can be applicable to several vehicle configurations.
Here is the select statement I am having trouble with. The error I am receiving is: Too few parameters: Expected 2.
Set rst = db.OpenRecordset("Select * from U_requirements where U_requirements.[U_RQ_ID] IN (Select U_Applicable_Configs.[U_RQ
Thank you!
Chaticathe
Learn from the best
Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.
Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 2 Answers and 8 Comments.
Try for 7 days”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.
Our community of experts have been thoroughly vetted for their expertise and industry experience.