Check to see where is wrong, part of the record not to come out-CodePudding

SELECT DISTINCT mann ling nanjing. *, [based data - key words]. *
Based data - FROM nanjing mann ling, [keywords]
The WHERE (((mann ling nanjing. Name of commodity) Like a '*' & amp; [key words] & amp; The '*'));

CodePudding user response:

refer to the original poster weixin_44052554 response:

SELECT DISTINCT mann ling nanjing. *, [based data - key words]. *
Based data - FROM nanjing mann ling, [keywords]
The WHERE (((mann ling nanjing. Name of commodity) Like a '*' & amp; [key words] & amp; The '*'));

For bosses to reassure

CodePudding user response:

Behind the VBA in the Like of the Access is to use %. The visual is the query SQL statement, I have not used,

Vba is roughly such,

Like & amp; '% keywords %'

CodePudding user response:

Estimate the "key words" here is a variable, then:

Like & amp; CRH (34) & amp; The '%' & amp; The keyword & amp; The '%' & amp; CRH (34)