Results 1 to 3 of 3
  1. #1
    Join Date
    Jul 2004

    Unanswered: Update field based on another field

    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.


  2. #2
    Join Date
    Jun 2004
    Arizona, USA
    Open the query editor. Go to the SQL view.

    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

  3. #3
    Join Date
    Mar 2003
    The Bottom of The Barrel
    Provided Answers: 1
    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...
    oh yeah... documentation... I have heard of that.

    *** What Do You Want In The MS Access Forum? ***

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts