I have a parameter query where I’m trying to use more than one parameter for the same field. Example: Cleveland And Detroit. When running the query, where it asks to enter parameter value i’ve tried CLEVELAND OR DETROIT, “CLEVELAND” OR “DETROIT”, LIKE “CLEVELAND” OR LIKE “DETROIT” but nothing seems to be working.
What am I doing wrong? Is there a better way?