Results 1 to 2 of 2
  1. #1
    Inaccessable is offline Novice
    Windows XP Access 2007
    Join Date
    Jul 2013
    Posts
    2

    How to Join Similar Fields Based on a Third Field?

    I'm new to Access and I'm sorry if this is something very simple.
    I have been having trouble figuring out how to assign specific numbers to a field based on the ID and another table holding the corresponding values through the use of queries.

    Table1 has a field that has three fields, the first being ID, the second being item description, and the third being an empty field for weight.
    Table2 has a two fields, the first being the ID, and the second being weight values that correspond to that ID.



    The purpose of the query is to assign values to the empty weight field in table 1 by assigning a weight value of the matching ID in table 2.

    Here's an example:
    Code:
    Table 1
    ID          Description  Weight
    2000001  Obj 1
    2000002  Obj 1 Blue
    2000003  Obj 3 
    
    Table 2
    ID          Description  Weight
    2000003  Obj 3           1.2
    2000001  Obj 1           3.5
    2000002  Obj 1 Blue      .4
    2000004  Obj 5           .25
    
    After the query:
    Table 1
    ID          Description  Weight
    2000001  Obj 1           3.5
    2000002  Obj 1 Blue      .4
    2000003  Obj 3           1.2
    Again, I am quite new to access, and information I have found insofar has not been sufficiently helpful. Any help will be met with much gratitude.

  2. #2
    June7's Avatar
    June7 is offline VIP
    Windows 7 64bit Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    52,919
    Is it really necessary to actually save the weight to Table1? You could just do a query that joins Table1 and Table2. Isn't even necessary to have the Description in Table1. Are there other fields in Table1? What is purpose of these two tables?
    How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.

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

Similar Threads

  1. Relating similar fields???
    By smoothlarryhughes in forum Access
    Replies: 10
    Last Post: 02-26-2013, 12:50 PM
  2. Replies: 2
    Last Post: 05-29-2012, 07:13 PM
  3. Replies: 3
    Last Post: 02-24-2012, 06:20 PM
  4. Fields populate based on another field
    By jlclark4 in forum Forms
    Replies: 3
    Last Post: 12-27-2011, 05:21 PM
  5. Help with something similar to join?
    By lagunov in forum Queries
    Replies: 7
    Last Post: 10-28-2010, 07:01 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
  •  
Other Forums: Microsoft Office Forums