I hope this one goes a little more smoothly. Again, I searched for this but was unsuccessful in finding the answer.
I'm trying to run an update query that will look for blanks (nulls) in one column and place an * in another field next to it (same record). Is there a way to set this up in the criteria section and just put an * in the Update To section of the query? Thanks for any help.
Paste the following into the editor & update your table and field names.
UPDATE YourTableName SET YourTableName.Field2 = "*"
WHERE YourTableName.Field1 Is Null;
Then, if you wish, go back to the design view.
"Lisa, in this house, we obey the laws of thermodynamics!" - Homer Simpson
"I have my standards. They may be low, but I have them!" - Bette Middler
"It's a book about a Spanish guy named Manual. You should read it." - Dilbert
Why would you possibly want to do this? Something tells me there's a better way to accomplish whatever it is you're after in a manner much more in line with accepted "best practices"... Or you could just have a really bizarre requirement...