Results 1 to 3 of 3
  1. #1
    Lortiz70 is offline Novice
    Windows 10 Access 2016
    Join Date
    Feb 2017
    Location
    Texas
    Posts
    3

    Combine information from 2 sources into one entry

    To clarify, one table is "Purchase Order" and one table is "Orders". I'm wanting to pull all parts for a specific time period and add them to the PO automatically.



    Part Order Qty
    PP-0001 12345 16
    PP-0001 23456 54
    PP-0001 34567 2
    PP-0085 12345 100

    I'm trying to figure out if I can automatically add the parts, sum the qty, then insert the order information so the line would read in each field the part, summed qty, and notes would show "12345, 23456, 34567".
    I have been manually adding the order information to the notes field and using InStr >0 to pull the information from the orders table for reports. Thanks in advance for the help. I hope I'm explaining it right.

  2. #2
    orange's Avatar
    orange is offline Moderator
    Windows 10 Access 2010 32bit
    Join Date
    Sep 2009
    Location
    Ottawa, Ontario, Canada; West Palm Beach FL
    Posts
    15,730
    It appears there are some things in your "business" that are missing from this post. We usually see Customer, Product/Item tables in addition to Orders. When PurchaseOrder is involved, there is often a Supplier as well. I recommend you tell us more about the business in plain English.
    Here is a link to lots of info on Database Planning and Design that you may find helpful.

    Good luck.

  3. #3
    ssanfu is offline Master of Nothing
    Windows 7 32bit Access 2010 32bit
    Join Date
    Sep 2010
    Location
    Anchorage, Alaska, USA
    Posts
    9,430
    And it would help if you could post your dB with a few example records (change any sensitive data).
    HTH
    -----
    Steve
    --------------------------------
    "Veni, Vidi, Velcro"
    (I came; I saw; I stuck around.)

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

Similar Threads

  1. Replies: 2
    Last Post: 02-05-2015, 03:51 PM
  2. Replies: 4
    Last Post: 11-25-2014, 11:23 AM
  3. Replies: 3
    Last Post: 05-02-2014, 09:27 AM
  4. How do I know the data sources of a report?
    By lookingforK in forum Reports
    Replies: 3
    Last Post: 04-10-2013, 09:19 AM
  5. Research sources
    By jgelpi16 in forum Programming
    Replies: 8
    Last Post: 02-04-2011, 07:25 AM

Tags for this Thread

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