Results 1 to 3 of 3
  1. #1
    jgs is offline Novice
    Windows 10 Access 2016
    Join Date
    Jul 2019
    Posts
    5

    combining data from two tables

    I am trying to do price sheets for a customer.



    A manufacturer gave me 2 Excel spreadsheets.

    The first is a complete listing of product ID, Desc, and normal pricing.

    The second is deviated pricing for select customers on (approx) 200 of 2,000 products.

    I would like to pull this into Access and either:

    Make a new table with all the products with original pricing for the 1800 items and the deviated pricing for the 200

    OR

    Write a query to pull form both tables with the correct pricing. So that I can then do a report with all the pricing.

    Inner and outer joins don't really work because I need parts of each table.

    Can someone point me in the right direction.

    Thanks,

    Jeb

  2. #2
    ranman256's Avatar
    ranman256 is offline VIP
    Windows Vista Access 2010 32bit
    Join Date
    Apr 2014
    Location
    Kentucky
    Posts
    8,419
    you can make a UNION query to pull data from 2 different tbls.
    select a,b,c from table1
    union
    select d,e,f from table2


    NOTE: both queries must have identical field types in the same order of each other. (field names aren't relevant)

  3. #3
    ssanfu is offline Master of Nothing
    Windows 7 32bit Access 2010 32bit
    Join Date
    Sep 2010
    Location
    Anchorage, Alaska, USA
    Posts
    8,950
    Import the two Excel spreadsheets into Access.

    Do you want to replace the pricing of the products that are identical with the discounted price?
    It sounds like each table has the same "product Id", so you could:

    1) Have the table with the 2,000 records and
    2) run an UPDATE query to update the 200 products updates with the deviated price products from the table with the 200 products. Note: the original price would be gone.


    Or you could add another field to the table with 2,000 products and run the UPDATE query to update the new field with the deviated product price.
    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. Combining data from 2 tables into 1 form
    By britney in forum Access
    Replies: 4
    Last Post: 01-28-2019, 12:31 PM
  2. Replies: 27
    Last Post: 02-14-2017, 09:36 AM
  3. Combining Data from two tables
    By psulions83 in forum Queries
    Replies: 2
    Last Post: 12-05-2014, 02:40 PM
  4. Replies: 3
    Last Post: 08-18-2012, 03:25 AM
  5. Replies: 4
    Last Post: 12-16-2009, 07:31 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 - Senior Forums