Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

In an update query.....how would I Update the fields containing "X" to "1" 1

Status
Not open for further replies.

Pack10

Programmer
Feb 3, 2010
495
US
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 ????
 
Your table isn't normalized...
What is your actual SQL code ?

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886
 

hi,

how about count(*) where field = 'X'

Skip,

[glasses]Just traded in my old subtlety...
for a NUANCE![tongue]
 
I actually used a variation of Skip's idea. I did a count where it was not null.
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top