Results 1 to 3 of 3
  1. #1
    lonlyspartakos is offline Novice
    Windows 8 Access 2010 32bit
    Join Date
    Oct 2015
    Posts
    9

    Wink problem at creating a query that linked to 2 tables :(

    here is the thing guys
    I have two tables linked through a key
    the thing is tbl2 has data that might linked to other data at tbl1.

    so when trying to create a query ( a query that has fields for both tables ) about all the data at tbl2 .
    only the linked data at both tables shows making all the data that is not related at tbl2 excluded.

    So is there away to make the data which is not related to tbl1 to show and the fields of tbl1 in the query show as blank?



    I know I might mis-explained it , so feel free to ask me to rephrase the whole thing

  2. #2
    ranman256's Avatar
    ranman256 is offline VIP
    Windows Vista Access 2010 32bit
    Join Date
    Apr 2014
    Location
    Kentucky
    Posts
    8,419
    You want an OUTER join.
    look it up on how to do it.

  3. #3
    lonlyspartakos is offline Novice
    Windows 8 Access 2010 32bit
    Join Date
    Oct 2015
    Posts
    9
    an OUTER join .. got it ..will do ..and feed you back

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

Similar Threads

  1. Replies: 3
    Last Post: 08-05-2015, 12:06 PM
  2. problem with linked tables
    By oreo in forum Access
    Replies: 5
    Last Post: 03-09-2015, 07:05 AM
  3. Replies: 6
    Last Post: 09-14-2013, 05:59 PM
  4. Problem creating linked table
    By rgrstvr in forum Access
    Replies: 16
    Last Post: 05-27-2013, 02:08 PM
  5. Problem with linked tables
    By meijermartijn in forum Import/Export Data
    Replies: 6
    Last Post: 08-24-2011, 01:48 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 - Senior Forums