Results 1 to 2 of 2
  1. #1
    Join Date
    Jun 2006
    Posts
    2

    Combining 2 fields from different tables into 1

    I am taking two inventory tables and combing them into 1 Query.

    What I am trying to do is take the "Purchase Order #" field from the tblPO and the "Sales Order #" field from the tblSo table and merge them into 1 column.

    This way I can start to look at the inventory data as if it were like an accounting worksheet with PO being positive numbers and SO being negative numbers.



    I assume this is a newbie question, but I just can't figure it out.

    Thanks for any and all help

  2. #2
    Join Date
    Jun 2006
    Location
    USA
    Posts
    6
    Hello:

    Step 1: Make a query with all your fields from your table.
    Step 2: In the design mode of this query after it is created, insert a new column with the insert key.
    Step 3: In the FIELD row of the new column enter any name for the column plus a colon, after that, enter your first field name surrounded by brackets if it has spaces in it, then enter the & character, then your second field name.
    Step 4: Run the query.

    This should show the combination of your fields.
    Regards
    Mark

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

Similar Threads

  1. Query to Display Tables & Fields
    By foxerator in forum Queries
    Replies: 0
    Last Post: 04-24-2008, 09:57 AM
  2. Replies: 1
    Last Post: 06-21-2007, 01:02 PM
  3. Replies: 0
    Last Post: 03-05-2007, 08:04 PM
  4. Combining Databases
    By RHall in forum Access
    Replies: 2
    Last Post: 04-13-2006, 07:36 AM
  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
  •  
Tech Forums: Microsoft Office Forums