AndrewKent
Well-known Member
- Joined
- Jul 26, 2006
- Messages
- 889
Hi folks,
I have written this query to pull data from Access into Excel:
it seems to work fine apart from the Like '*or*' part. I am trying to pull out all records that contain the word or in that column but I'm not sure I have written it correctly because it is not pulling any of them.
Can anyone help?
Andy
I have written this query to pull data from Access into Excel:
Code:
Query = "SELECT tblData_ActivityReport.ActvityReport_EventType, tblData_ActivityReport.ActvityReport_ContractCode, " _
& "tblData_Codes.Claimed_Referral_ID, tblData_ActivityReport.ActvityReport_WeekNo, tblData_ActivityReport.ActvityReport_SellerCode, " _
& "tblData_ActivityReport.ActvityReport_IntroducerName, tblData_ActivityReport.ActvityReport_CustomerName, tblDefinition_ProductCode.ProductCode_Type, " _
& "tblData_ActivityReport.ActvityReport_FPD_Credit FROM (tblDefinition_ProductCode RIGHT JOIN tblData_ActivityReport ON " _
& "tblDefinition_ProductCode.ActvityReport_ProductCode = tblData_ActivityReport.ActvityReport_ProductCode) LEFT JOIN tblData_Codes ON " _
& "tblData_ActivityReport.ActvityReport_ContractCode = tblData_Codes.ActivityReport_ContractCode WHERE (((tblData_Codes.Claimed_Referral_ID) Is Null Or " _
& "(tblData_Codes.Claimed_Referral_ID) = 'Too Many Matches' Or (tblData_Codes.Claimed_Referral_ID) Like '*or*')) ORDER BY " _
& "tblData_ActivityReport.ActvityReport_ContractCode, tblData_ActivityReport.ActvityReport_WeekNo;"
it seems to work fine apart from the Like '*or*' part. I am trying to pull out all records that contain the word or in that column but I'm not sure I have written it correctly because it is not pulling any of them.
Can anyone help?
Andy