Why do my criteria get turned into parameter queries?

[j_Southern]

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

[j_Southern]

I have not got a reaction to my recent posting, is this because it relates to MSQuery?
If this is the reason, can any one suggest a source of information that may be able to help.
John