Attend Excelapalooza
Thanks Thanks:  0
Likes Likes:  0
Results 1 to 2 of 2

Thread: Join properties question

  1. #1
    Board Regular
    Join Date
    Jul 2011
    Location
    Southern California
    Posts
    145
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Join properties question

    Hi, I was wondering if something was possible within Access queries. I wanted to join a field with one table to two possible fields in another table. Essentially the value in field "A" in Table1 could be found in field "A" or "B" in Table2. Table 1 has my list of unique values that I want to pull. What type of join would I have to do if this were possible?

    Thanks,

    Jesse

  2. #2
    MrExcel MVP
    Moderator
    Joe4's Avatar
    Join Date
    Aug 2002
    Posts
    45,191
    Post Thanks / Like
    Mentioned
    32 Post(s)
    Tagged
    4 Thread(s)

    Default Re: Join properties question

    Typically, you would add Table 2 twice, and have two separate joins (one for each field).
    TIPS FOR FINDING EXCEL SOLUTIONS
    1. Use the built-in Help that comes with Excel/Access
    2. Use the Search functionality on this board
    3. A lot of VBA code can be acquired by using the Macro Recorder.

    "Give a man a fish, feed him for a day. Teach a man to fish, feed him for life!"

User Tag List

Tags for this Thread

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

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

 

DMCA.com