LiveByTheCoad
New member
- Local time
- Today, 04:36
- Joined
- Jul 4, 2014
- Messages
- 5
Hi there,
I was hoping someone can help me create a specific query.
The data i'm trying to capture is basically from 5 combo boxes which have corresponding selections.
But what I need to do is even if options 2-5 aren't filled out I still need to capture the details.
I have the beginning of code but it only captures if all 5 fields are completed.
If anyone can assist that'd be great.
This is the code that I have so far:
SELECT tblFLSFeedback.*, tblProductOpportunity.ProductName, tblSalesOpportunityType.SalesOppType, tblProductOpportunity_1.ProductName, tblSalesOpportunityType_1.SalesOppType, tblProductOpportunity_2.ProductName, tblSalesOpportunityType_2.SalesOppType, tblProductOpportunity_3.ProductName, tblSalesOpportunityType_3.SalesOppType, tblProductOpportunity_4.ProductName, tblSalesOpportunityType_4.SalesOppType
FROM tblSalesOpportunityType AS tblSalesOpportunityType_4 INNER JOIN (tblProductOpportunity AS tblProductOpportunity_4 INNER JOIN (tblSalesOpportunityType AS tblSalesOpportunityType_3 INNER JOIN (tblProductOpportunity AS tblProductOpportunity_3 INNER JOIN (tblSalesOpportunityType AS tblSalesOpportunityType_2 INNER JOIN (tblProductOpportunity AS tblProductOpportunity_2 INNER JOIN (tblSalesOpportunityType AS tblSalesOpportunityType_1 INNER JOIN (tblProductOpportunity AS tblProductOpportunity_1 INNER JOIN (tblSalesOpportunityType INNER JOIN (tblProductOpportunity INNER JOIN tblFLSFeedback ON tblProductOpportunity.ProductID = tblFLSFeedback.ProdOpp1) ON tblSalesOpportunityType.SalesOppID = tblFLSFeedback.SaleOpp1) ON tblProductOpportunity_1.ProductID = tblFLSFeedback.ProdOpp2) ON tblSalesOpportunityType_1.SalesOppID = tblFLSFeedback.SaleOpp2) ON tblProductOpportunity_2.ProductID = tblFLSFeedback.ProdOpp3) ON tblSalesOpportunityType_2.SalesOppID = tblFLSFeedback.SaleOpp3) ON tblProductOpportunity_3.ProductID = tblFLSFeedback.ProdOpp4) ON tblSalesOpportunityType_3.SalesOppID = tblFLSFeedback.SaleOpp4) ON tblProductOpportunity_4.ProductID = tblFLSFeedback.ProdOpp5) ON tblSalesOpportunityType_4.SalesOppID = tblFLSFeedback.SaleOpp5;
I was hoping someone can help me create a specific query.
The data i'm trying to capture is basically from 5 combo boxes which have corresponding selections.
But what I need to do is even if options 2-5 aren't filled out I still need to capture the details.
I have the beginning of code but it only captures if all 5 fields are completed.
If anyone can assist that'd be great.
This is the code that I have so far:
SELECT tblFLSFeedback.*, tblProductOpportunity.ProductName, tblSalesOpportunityType.SalesOppType, tblProductOpportunity_1.ProductName, tblSalesOpportunityType_1.SalesOppType, tblProductOpportunity_2.ProductName, tblSalesOpportunityType_2.SalesOppType, tblProductOpportunity_3.ProductName, tblSalesOpportunityType_3.SalesOppType, tblProductOpportunity_4.ProductName, tblSalesOpportunityType_4.SalesOppType
FROM tblSalesOpportunityType AS tblSalesOpportunityType_4 INNER JOIN (tblProductOpportunity AS tblProductOpportunity_4 INNER JOIN (tblSalesOpportunityType AS tblSalesOpportunityType_3 INNER JOIN (tblProductOpportunity AS tblProductOpportunity_3 INNER JOIN (tblSalesOpportunityType AS tblSalesOpportunityType_2 INNER JOIN (tblProductOpportunity AS tblProductOpportunity_2 INNER JOIN (tblSalesOpportunityType AS tblSalesOpportunityType_1 INNER JOIN (tblProductOpportunity AS tblProductOpportunity_1 INNER JOIN (tblSalesOpportunityType INNER JOIN (tblProductOpportunity INNER JOIN tblFLSFeedback ON tblProductOpportunity.ProductID = tblFLSFeedback.ProdOpp1) ON tblSalesOpportunityType.SalesOppID = tblFLSFeedback.SaleOpp1) ON tblProductOpportunity_1.ProductID = tblFLSFeedback.ProdOpp2) ON tblSalesOpportunityType_1.SalesOppID = tblFLSFeedback.SaleOpp2) ON tblProductOpportunity_2.ProductID = tblFLSFeedback.ProdOpp3) ON tblSalesOpportunityType_2.SalesOppID = tblFLSFeedback.SaleOpp3) ON tblProductOpportunity_3.ProductID = tblFLSFeedback.ProdOpp4) ON tblSalesOpportunityType_3.SalesOppID = tblFLSFeedback.SaleOpp4) ON tblProductOpportunity_4.ProductID = tblFLSFeedback.ProdOpp5) ON tblSalesOpportunityType_4.SalesOppID = tblFLSFeedback.SaleOpp5;