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

    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.

    David

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

    Paste the following into the editor & update your table and field names.

    Code:
    UPDATE  YourTableName SET YourTableName.Field2 = "*"
    WHERE YourTableName.Field1 Is Null;
    Then, if you wish, go back to the design view.
    Lou
    使大吃一惊
    "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
    Location
    The Bottom of The Barrel
    Posts
    6,102
    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
  •