Results 1 to 2 of 2
  1. #1
    Lounger
    Join Date
    Jul 2002
    Location
    Indianapolis, Indiana
    Posts
    29
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Update-Replace Query (97 - 2)

    Greetings,

    I have a field called EOE (Element of Expense). It's a text field, length 4.

    I need an update query that will change all EOE <> 1198, 1199, 1250 to 1198.

    So...if the EOE Is Not 1198 Or 1199 Or 1250, change the EOE to 1198.

    In this example, there are 750 records...of which 453 ARE NOT 1198, 1199, or 1250. Its these 453 records that I want to change to 1198.

    Thanks in advance !!

  2. #2
    Super Moderator
    Join Date
    Jun 2002
    Location
    Mt Macedon, Victoria, Australia
    Posts
    3,993
    Thanks
    1
    Thanked 45 Times in 44 Posts

    Re: Update-Replace Query (97 - 2)

    Create a new query, change it to an update query, include the field EOE, put the value "1198" in the update line, and in the criteria line put :

    Not in ("1198", "1199", "1250")
    Regards
    John



Posting Permissions

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