Results 1 to 4 of 4
  1. #1
    Join Date
    Mar 2019
    Posts
    2

    Query to pull price from master price

    I have question.
    I use access 2016 and want to create query and and add price column

    Basically I have table master_price and raw_data

    Master Price :
    Click image for larger version. 

Name:	Master_Price.jpg 
Views:	10 
Size:	22.7 KB 
ID:	37905

    and I have rawdata like this :

    Click image for larger version. 

Name:	RawData.jpg 
Views:	10 
Size:	47.5 KB 
ID:	37906

    Which formula I need to use to pull price data from master_price ?



    Thanks so much,
    Jonathan

  2. #2
    June7's Avatar
    June7 is offline VIP
    Windows 10 Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    52,815
    Do a compound join on Brand and Item fields.
    How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.

  3. #3
    Join Date
    Mar 2019
    Posts
    2
    Hi,

    Thanks so much for your reply.
    My access skill is very limited, could you do me a favor giving example script to do compound join ?

    Jonathan

  4. #4
    June7's Avatar
    June7 is offline VIP
    Windows 10 Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    52,815
    Use the query builder and grab and drag a link line from one table to another on both pairs of fields. Very simple. Then switch to SQLView to see the SQL statement.

    If you build these links in Relationship builder, they will automatically appear in query.

    https://www.opengatesw.net/ms-access...cess-Query.htm
    How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.

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

Similar Threads

  1. Replies: 3
    Last Post: 10-30-2018, 09:48 AM
  2. Order Entry Form - Case Price vs. Unit Price
    By Kaloyanides in forum Access
    Replies: 4
    Last Post: 05-18-2017, 06:31 AM
  3. Replies: 22
    Last Post: 12-20-2015, 02:46 AM
  4. Replies: 17
    Last Post: 12-14-2015, 10:23 PM
  5. Item without price, or duplicate price
    By Auto in forum Reports
    Replies: 5
    Last Post: 07-29-2013, 09:46 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