MS Access Query
I have a dateset of 1000’s of projects. I am adding a new Field called Pinned. I want every Job # that contains an Asterisk to have a Yes (or True) value for the Pinned Field.
In Design View “Select” I have it looking like this”
In Design View “Update” I have it looking like this:
But My results after I run it do not mark “Yes” (or True) by checking off the box under the Pinned Field, it looks like this after I run the query:
Here is how my SQL looks:
I looks like in the SQL that it is not doing any “Update to” items??
Help an amateur access guy out please!
Log in to reply.