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
    149
    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,530
    Post Thanks / Like
    Mentioned
    34 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!"

Some videos you may like

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
  •