Hi,
I am trying to add two text criteria to a query to exclude results that contain either word/phrase. I have tried the following:
WHERE (((Matches.Result) Not Like "*D/L*" And (Matches.Result)<>"No result"));
and
WHERE (((Matches.Result) Not Like "%D/L%" And (Matches.Result)<>"No result"));
The first gives the correct result in Access but not when the query is imported into Excel. The second gives the correct result when imported into Excel but not in Access.
Is there a way to get the correct result in both? I am using Access 2016.
Thanks
I am trying to add two text criteria to a query to exclude results that contain either word/phrase. I have tried the following:
WHERE (((Matches.Result) Not Like "*D/L*" And (Matches.Result)<>"No result"));
and
WHERE (((Matches.Result) Not Like "%D/L%" And (Matches.Result)<>"No result"));
The first gives the correct result in Access but not when the query is imported into Excel. The second gives the correct result when imported into Excel but not in Access.
Is there a way to get the correct result in both? I am using Access 2016.
Thanks