Hi all,
I am relatively new to Access, so please excuse the layman's terms.
I built a query that calculates values according to what data a user enters into a field. Please see the expression that is typed into the column below.
LS1Value: Switch([LS1]=Yes,1,[LS1]=More Or Less,1)
The language here ("More or Less") cannot be changed as it corresponds to a survey and needs to reflect that survey exactly. A score is calculated based on the survey answers.
When I try to run this query, the parameter value box pops up and I can't seem to get it to stop. As you can see, I do not have brackets around the words "More or Less". I also ensured there were no brackets in the SQL view. There is also nothing in the criteria row.
Could this be because the words "more" and "less" are some kind of automatic identifiers in Access? Any guidance would be greatly appreciated.
Thanks!