Please help!

I have (what I thought was) a very simple single table query, but I am
struggling with it in MS Query. I can do it using stored procedures
and ADO, but that would probably be overkill for such a small query and
I will only resort to that if somebody confirms that is impossible to
achieve using MS Query

My problem is that the parameter that the users will enter (location
code) is a substring of item code in the table. There can be more than
1 item code with the same location code embedded in it and this is what
the report seeks to identify. However the location code substring will
have varying start points and lengths so I don't think I can use
substring in this context.

I can get results for a single location code by using LIKE
eg dxobv1 LIKE '%GBWA10%',
but am struggling with the syntax of replacing GBWA10 with an input
parameter.
Something like dxobv1 LIKE '%[Please input location code]%'

Can anybody confirm whether or not this is possible to do using
MSQuery, and if so, could they confirm the syntax for me to use.
including the parameter prompt.

Many thanks in advance!