Results 1 to 2 of 2
  1. #1
    Join Date
    Jun 2007
    Posts
    4

    Combining columns from multiple tables/queries into one?

    Is there a way to pull the results from several queries/tables into one table/query and only compare it to one variable?

    For example, I have an Excel spreadsheet that is set up with every PO number available. The other fields in the spreadsheet may contain data or they may be blank.

    PO | Date Created | Date Received
    1 11/5/1955 11/5/1985
    2
    3 8/6/7530 9/8/7530
    4
    5 ----------------- 12/20/05
    6 1/1/1985
    7 1/1/1980
    8 ----------------- 12/21/05
    9 ----------------- 12/21/05
    10



    Is there any way to pull all the data from "Date Created" but only have it compare the table's relationship with the PO number and not also the "Date Received" column?

  2. #2
    Join Date
    Jun 2007
    Posts
    4
    Mostly solved with a LEFT join on the PO data. I have several other fields that I believe need to have their relationships reworked to get the results I am looking for.

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

Similar Threads

  1. Combining Two Queries
    By csolomon in forum Queries
    Replies: 1
    Last Post: 09-03-2009, 01:33 PM
  2. Combining like update queries
    By xcr800man in forum Queries
    Replies: 2
    Last Post: 05-20-2008, 08:36 AM
  3. Replies: 1
    Last Post: 06-03-2006, 05:02 PM
  4. Replies: 0
    Last Post: 03-19-2006, 11:52 PM
  5. Help combining 3 tables
    By luscioussarita in forum Queries
    Replies: 1
    Last Post: 12-14-2005, 03:22 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