Prompt user for a list of values in a query

[Guiom]

Is it possible to a parameter query that would prompt the user for a list of
values rather than a single value.
For example, the user could enter UK and France and the query would only
return those customers who are in tose 2 countries.
Thanks

 

[KARL DEWEY]

There is a way but possible problems if your data has partial duplicates ( US
USSR BRUSSELS ) as US is match within the others.

In design view add a calculated field in thr FIELD row like this --
Expr1: [Enter search data separate by space ( UK FR GR )]
In the criteria row under the above enter this --
Like "*" & [YourDataField] & "*"