vba sql wild card passing in code
access 2010 vba sql
I have a wild card sql i'm trying to pass in MODULE vba
WHERE Core2.RICHTEXT LIKE '"%PIZZA%" AND Core2.RICHTEXT Like "%CUTTER%"';
is this syntax correct...above
In a standard query window sql this works:
WHERE Core2.RICHTEXT Like "*pizza*" And Core2.RICHTEXT Like "*cutter*"));
Thanks
fordraiders
I have a wild card sql i'm trying to pass in MODULE vba
WHERE Core2.RICHTEXT LIKE '"%PIZZA%" AND Core2.RICHTEXT Like "%CUTTER%"';
is this syntax correct...above
In a standard query window sql this works:
WHERE Core2.RICHTEXT Like "*pizza*" And Core2.RICHTEXT Like "*cutter*"));
Thanks
fordraiders
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER