Results 1 to 2 of 2
  1. #1
    jmuirman1 is offline Advanced Beginner
    Windows 10 Access 2016
    Join Date
    Aug 2016
    Posts
    84

    How to expand number of joined tables

    I HAVE LEFT TABLE (tnewcases) JOINED TO 6 RIGHT TABLES (tcontacts) - I NEED MORE RIGHT TABLES JOINED.



    HOW DO I DO THAT?

    THANKS,

    JOHN

  2. #2
    ItsMe's Avatar
    ItsMe is offline Sometimes Helpful
    Windows 8 Access 2013
    Join Date
    Aug 2013
    Posts
    7,862
    From the query designer, you can drag additional tables onto the design surface. After you define an inner join, you can go to the JOIN properties by clicking the 'line'.
    .
    Click image for larger version. 

Name:	JoinProp.jpg 
Views:	8 
Size:	31.1 KB 
ID:	25775

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

Similar Threads

  1. Issue with joined tables in a query
    By Magnolia1 in forum Access
    Replies: 2
    Last Post: 05-13-2016, 04:51 PM
  2. Link one table to 2 already joined tables
    By GabrielloG in forum Database Design
    Replies: 10
    Last Post: 12-17-2014, 05:00 PM
  3. Counter in a query with joined tables
    By plus_stick in forum Queries
    Replies: 1
    Last Post: 10-30-2014, 06:36 AM
  4. Replies: 8
    Last Post: 06-04-2014, 10:01 AM
  5. Multiple Tables Joined ????
    By Ekim in forum Database Design
    Replies: 10
    Last Post: 01-15-2012, 07:08 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