Parameter search in Union query

[templeowls]

I have a union query between two queries. The current SQL is:




SELECT * FROM 2018Query
UNION ALL SELECT * FROM 2019Query;


I'd like to add a parameter search. I had one previously on a non-union query that worked perfectly, but this was in design view and idk how to add this to SQL View. In the criteria cell in the non-union query, I had:


Like "*" & [Search text] & "*"

[pbaldy]

Same answer as given elsewhere

SELECT * FROM 2018Query
WHERE FieldName Like...
UNION ALL
SELECT...

[JoeM]

Another option is to save the original Union query with no parameters.
Then, create another query based off of that Union query, and you will be able to use the Query Builder and add the criteria like you are used to.
(There is nothing wrong with doing a query of a query).