I have a query that returns data based on the contents of Cell A2 (Product code)
My Query Criteria currently looks like
Product = [PROD]
PROD is populated by A2 and refreshes on change.
I now want to change this to a wildcard search.
If I directly change this on the
Product like %PCB%
it returns the date I wanted.
However I still want the user to be able to enter the criteria.
I have tried
Product like %[PROD]%
and
Product like [PROD]
Where [PROD] in A2 = "%"&A1&"%"
Neither of these options are working. I am sure option 2 has worked in the past but maybe I have the syntax wrong.
Any Suggestions?
My Query Criteria currently looks like
Product = [PROD]
PROD is populated by A2 and refreshes on change.
I now want to change this to a wildcard search.
If I directly change this on the
Product like %PCB%
it returns the date I wanted.
However I still want the user to be able to enter the criteria.
I have tried
Product like %[PROD]%
and
Product like [PROD]
Where [PROD] in A2 = "%"&A1&"%"
Neither of these options are working. I am sure option 2 has worked in the past but maybe I have the syntax wrong.
Any Suggestions?