Not sure why I can't get this right, but i have an update query that I can't get right.
The table contains answers to questions where the user places an "X" in the field.
After I import these spread sheets to a table, I want to replace the X with a "1" so we can add them up.
In the Query grid I have the following
Country Question 1 Yes Question 1 No Question 2 Yes Question 2 No ...... Question 5
Malaysia X X X
I can't get the criteria right. Would'nt it be update to: "1" and criteria = "X" in the OR condition ????
The table contains answers to questions where the user places an "X" in the field.
After I import these spread sheets to a table, I want to replace the X with a "1" so we can add them up.
In the Query grid I have the following
Country Question 1 Yes Question 1 No Question 2 Yes Question 2 No ...... Question 5
Malaysia X X X
I can't get the criteria right. Would'nt it be update to: "1" and criteria = "X" in the OR condition ????