Results 1 to 2 of 2
  1. #1
    niihla10 is offline Novice
    Windows Vista Access 2007
    Join Date
    Aug 2009

    Complex Update query

    I'm trying to run an update query to input a category based on a certain column.

    For example column Seniority has number 0-25
    I want to update column Level (currently blank) so that it shows what level they are in (e.g. Level 1 for 0-3 yrs seniority).

    Any idea how to do this? I was trying use expression builder in the "update to" field in update query, but I'm not sure what to write...

    Please please help!

  2. #2
    timo1999 is offline Novice
    Windows XP Access 97
    Join Date
    Aug 2009
    Open a new query in design view.
    When the box pops up, click on the table you are working with, and click on "Add".
    Then click on close so the pop up box will go away.

    You will see a blank query design page with the table you are working with in the top left.
    Find and click on the "Seniority" field and drag it down to the empty columns below to where you see "field"
    Now find the "Level" field and drag it down next to the Seniority field.

    Now under the "Seniority" column, click on the Criteria cell, and type in "Between 0 And 3"
    Under the "Level" column, click on the cell that lines up with "Update To"
    Type in "LEVEL 1". When you click away from this cell, notice Access will automatically place " " around the LEVEL 1 text. This field need to be a TEXT field for this to work.

    Now you can click on the exclamation point to run the query. After it updates all the records that fall between 0 and 3, you can now change the criteria according to the next range of years for LEVEL 2 and run the query again, and continue till this process until you reach the highest level.


Please reply to this thread with any new information or opinions.

Similar Threads

  1. Update Query
    By Najeeb in forum Queries
    Replies: 1
    Last Post: 11-19-2015, 04:02 AM
  2. Replies: 2
    Last Post: 08-26-2009, 10:43 AM
  3. Replies: 1
    Last Post: 07-08-2009, 03:31 PM
  4. Complex Date Comm/Amt Formula
    By JLongo in forum Programming
    Replies: 0
    Last Post: 11-21-2008, 10:24 AM
  5. Need help with an Update query ...
    By valkyry in forum Queries
    Replies: 0
    Last Post: 04-23-2007, 08:45 PM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
Other Forums: Microsoft Office Forums