Results 1 to 2 of 2

Update Query

  1. #1
    cmiyatake is offline Novice
    Windows 10 Access 2016
    Join Date
    Jul 2019
    Posts
    28

    Update Query


    is it possible for an Update Query to contain a Parameter Criteria?

    What I am trying do is to select a specific criteria in one field and then populate specific data in 2 other fields.

    For example,

    Field 1: Vulnerability Summary using a Like Criteria where I enter a word string......Roofing
    Field 2: Risk where I would like to populate the field according to what is entered in Field 1.... Medium
    Field 3: Difficulty...same as the criteria for field 2.... Moderate

    Is this possible? If not, how can I accomplish my objective?


    Thank You

  2. #2
    rpeare is offline VIP
    Windows XP Access 2003
    Join Date
    Jul 2011
    Posts
    5,440
    I would tend to do this with a table rather than relying on a free-form typing.

    For instance
    Code:
    tblVulnerabilityCategory
    VC_ID  VC_Description
    1      Roofing
    
    tblRisk
    R_ID  R_Description
    1      Low
    2      Medium
    3      High
    
    tblDifficulty
    D_ID  D_Description
    1      Easy
    2      Moderate
    3      Super Hard
    
    tblVulnerability
    V_ID  VC_ID  R_ID  D_ID
    1     1      2     2
    This way you have a defined structure you can change as need demands without having to edit your query every time a change is made. The added benefit being your update query then just becomes a lookup based on a choice from a combo box or other similar mechanism.

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

Similar Threads

  1. Replies: 1
    Last Post: 03-11-2018, 11:44 AM
  2. Replies: 2
    Last Post: 08-03-2017, 04:58 AM
  3. Replies: 1
    Last Post: 10-27-2016, 12:14 PM
  4. Replies: 7
    Last Post: 08-26-2013, 06:05 AM
  5. Replies: 2
    Last Post: 08-30-2012, 07:59 AM

Posting Permissions

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