MS Query with Parameters and "contains" filter

[his_holiness]

I'm trying to build an MS Query in Excel using the wizard and want to filter the results based on one value being contained in any record. I can set a query where the parameter is fixed (ie the field value equals exactly the parameter value), but want to pick up all fields containing the value of the parameter (eg set parameter to test and want results from the field with values such as "test", "test1", test_uat1" etc etc. Can someone tell me the syntax to put in the criteria fields of the MS query wizard? I have tried :

 

like '%' & [order] & '%'

 

but get an error message. A bit stuck now.....

thanks in advance