Hello,
I am updating the StatusID field in a table using an update query. Can I update one field with different values in the Criteria field and the Update To: field? I have to update the values if StatusID says "Complete" update to "1", if StatusID says, etc. (pic below)
https://drive.google.com/open?id=0B9IyKJSJ52ghRHlCNTYxdjNiU2s
I tried adding StatusID field 3 times and putting the Criteria on the same row but my query was blank (b/c I believe is saying I'm look for Complete AND Not Started AND, etc.) But I tried adding the Criteria staggered in the OR fields (pictured above) and I came up with results that I'm not comfortable with hitting Run to Update the table. (see below)
https://drive.google.com/open?id=0B9IyKJSJ52ghRFJDTzMySkFXWnM
How do you update a single field with multiple criteria and multiple update to: values using a query (if you know in SQL that is fine, as well, but also I would like to know in a query, please)?
Thank you.
I am updating the StatusID field in a table using an update query. Can I update one field with different values in the Criteria field and the Update To: field? I have to update the values if StatusID says "Complete" update to "1", if StatusID says, etc. (pic below)
https://drive.google.com/open?id=0B9IyKJSJ52ghRHlCNTYxdjNiU2s
I tried adding StatusID field 3 times and putting the Criteria on the same row but my query was blank (b/c I believe is saying I'm look for Complete AND Not Started AND, etc.) But I tried adding the Criteria staggered in the OR fields (pictured above) and I came up with results that I'm not comfortable with hitting Run to Update the table. (see below)
https://drive.google.com/open?id=0B9IyKJSJ52ghRFJDTzMySkFXWnM
How do you update a single field with multiple criteria and multiple update to: values using a query (if you know in SQL that is fine, as well, but also I would like to know in a query, please)?
Thank you.