I am using MSQuery with an SQL Database to filter data into Excel.
I have a field Transaction_Type which can have values of from "1" to "5" (they are text not numbers)
I wish only to include only types"1" and "4" in my query, so I use, in the criteria part of MSQuery:-

Transaction_Type

='1' or '4'
This immediately transforms into a parameter and I am invited to enter a value in the popup window.
If I surround the values with no quotes or "" I get a Syntax error note.
How should I write the criterion to get a proper answer?
I hope this is a proper question for this Forum.
John