Results 1 to 3 of 3
  1. #1
    adam1218.ac is offline Novice
    Windows 10 Access 2010 32bit
    Join Date
    Oct 2016
    Posts
    2

    Combing Tables in Query Ignoring Dates

    So I will start off by saying that I am very new to Access and learning as I go, but cant seem to find and answer to this and hoping someone could help.

    I have two tables, the first table has dates from January 2015-December 2016 with actual sales information (book qty, Book Amt , Net Invoice amount, Net Invoice Qty). The second table has date ranges from 6/2015 through 3/2018 with Forecasted Sales, Forecasted Dollars, etc.

    I was able to bring them together to one table, however it only is pulling data from 2016 which makes sense because those dates match in the relationship. My question is does anyone know a way around that to illustrate all dates with out messing with the original data?

  2. #2
    CJ_London is offline VIP
    Windows 10 Access 2010 32bit
    Join Date
    Mar 2015
    Posts
    11,397
    use a left join rather than an inner join - right click on existing join and select join properties.

  3. #3
    adam1218.ac is offline Novice
    Windows 10 Access 2010 32bit
    Join Date
    Oct 2016
    Posts
    2
    You sir are the Man! Thank you very much! It worked perfectly!

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

Similar Threads

  1. Replies: 11
    Last Post: 11-09-2012, 08:17 AM
  2. Combing two tables with missing dates
    By Jerseynjphillypa in forum Queries
    Replies: 1
    Last Post: 07-19-2012, 10:51 AM
  3. Combing two tables together
    By Jerseynjphillypa in forum Queries
    Replies: 7
    Last Post: 06-14-2012, 12:07 PM
  4. Macro Help with Combing Table with Date Query
    By Jerseynjphillypa in forum Programming
    Replies: 15
    Last Post: 05-03-2012, 10:25 AM
  5. Count Query w/o ignoring Nulls
    By Dulanic in forum Queries
    Replies: 3
    Last Post: 03-21-2012, 11:56 AM

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