Acces Query in VBA

[AndrewKent]

Hi folks,

I have written this query to pull data from Access into Excel:

    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

 

[Fazza]

Hi, Andy.

Please try the % wildcard instead of *

regards, F

 

[AndrewKent]

Perfect, thanks!

 

[Fazza]