Results 1 to 6 of 6
  1. #1
    Join Date
    Aug 2006
    Posts
    10

    Unanswered: Multiple Tables in Query

    I have a query based on four tables in which I am creating a
    report from. Each table has it's own form associated with it and
    all the forms are subforms of one large form. The query will
    pull the records only if information has been inputted in all
    four tables via the forms. I would like for the query to pull all records
    with all the fields associated with the query have been or have not been filled.
    I think it is something simple I am missing, but just can't seem
    to get it. By the way, I am a newbie with Access.
    Thanks.

  2. #2
    Join Date
    Jun 2004
    Location
    Seattle, WA
    Posts
    601
    without knowing the tables or anything, this may be a bit much to do with the simple query editor because you will have to tell it to match certain things. If you can provide a bit more information, we can try to help.
    Ryan
    My Blog

  3. #3
    Join Date
    Feb 2004
    Posts
    90
    Try double clicking on the joins within the query. You'll see some options.

  4. #4
    Join Date
    Feb 2004
    Location
    New Zealand
    Posts
    1,423
    Provided Answers: 8
    Look @ how you are joining the Table in the Query

    Inner join , outer join , Left join right join

    Just right click on the Black line joining the tables

    Join properties

    just read the
    3 option pick one

    Then Have a look at the SQL then the
    Inner join , outer join , Left join right join start making sents
    hope this help

    See clear as mud


    StePhan McKillen
    the aim is store once, not store multiple times
    Remember... Optimize 'til you die!
    Progaming environment:
    Access based on my own environment: DAO3.6/A97/A2000/A2003/A2007/A2010
    VB based on my own environment: vb6 sp5
    ASP based on my own environment: 5.6
    VB-NET based on my own environment started 2007
    SQL-2005 based on my own environment started 2008
    MYLE
    YOUR PASSWORD IS JUST LIKE YOUR TOOTHBRUSH DON'T SHARE IT.

  5. #5
    Join Date
    Aug 2006
    Posts
    10
    Thanks Goldy and Myle! I had forgot about those options. I chose number 2 and it seems to be working. I have another query that is doing the same and I am going to try it on that one as well.

    Thanks again!

  6. #6
    Join Date
    Feb 2004
    Location
    New Zealand
    Posts
    1,423
    Provided Answers: 8
    Don't just pick option 2 all the time

    2 and 3 change depending on a the way they were joined left or right

    You can have heap of fun with those join like showing User What is Missing

    eg.

    I have a database then colllect data From Differance points

    as i know the Point to collect from
    So I have a Query That Show me Null Blanks records of the Differnace points that hav'nt been read yet.
    hope this help

    See clear as mud


    StePhan McKillen
    the aim is store once, not store multiple times
    Remember... Optimize 'til you die!
    Progaming environment:
    Access based on my own environment: DAO3.6/A97/A2000/A2003/A2007/A2010
    VB based on my own environment: vb6 sp5
    ASP based on my own environment: 5.6
    VB-NET based on my own environment started 2007
    SQL-2005 based on my own environment started 2008
    MYLE
    YOUR PASSWORD IS JUST LIKE YOUR TOOTHBRUSH DON'T SHARE IT.

Posting Permissions

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