joins

  1. T

    Form entry to create join between two tables

    Hi, I'm relatively new to Access. I have two main tables, essentially these are item masters with unique records: "SupplierParts" & "MyParts" Many supplier parts can relate to one MyPart i.e.: MyPart SupplierPart Part1 Part1 Part1 Part2 Part1 Part3 Etc... I have created a third...
  2. D

    Power Query 2016 - Missing Options - Merge dropdown - Joins

    Hi Everyone, I am using Microsoft Office Professional Plus 2016 and Inoticed I am missing some features inside of Power Query. I came across some ofthe missing features while attempting to merge two tables. The merge button inthe queries button does not have the drop down feature to allow the...
  3. P

    Join tables based on a non-unique ID and a formula

    Hi Everyone - I have three sets of data. One is organized like this: Table1 <tbody> Product ID Start Date Code 121 4/05/2018 X 131 4/05/2018 V 121 4/20/2018 </tbody> Another like this: Table2 <tbody> Product ID Buy Date 121 4/06/2018 131 4/06/2018 121 4/07/2018 121...
  4. M

    Power pivot question I can't even articulate in a title

    I have data like: Measure date1 date2 1 1 2 2 1 2 4 2 2 8 2 1 16 1 1 And I'd like to make a table like Dates 1 2 date1 1...
  5. T

    multiple table relationships

    Hi I have 2 tables as per below, table 1 has the exact people i require in it but table 2 has an extra bit of detail i need to pull in. Currently i have created 2 relationship from table 1 to table 2 (firstName - ChristianName) and (Surname - SecondName). these are on a include all records from...
  6. J

    Need help with joins and queries

    Hello, I am very new to access and am having trouble getting started. I have acquired an already constructed access database and am trying to pull out data in a specific format so I can run some stats. I have multiple tables, two of which contain the information I am after. One of the tables...
  7. C

    Need help - newbie with outer/inner joins issue

    Hi, I am new to using SQL/Access. I am trying to build a query that produces a "bill of materials" for a store remodel. The content of the bill of materials should change based on the type of the store or the type of item (either I need to add items or add additional detail or spec to an...
  8. G

    How to combine records from multipe tables into one query?

    Dear All, Using Access 2007, I am trying to bring together records from three tables: Open Purchase Orders, Inventory, and Open Sales Orders. I want to determine: Do we have sufficient quantities on order and in inventory to fill each sales order, indicating whether we need to buy more. Do...
  9. T

    Calculation on Group

    I am preparing a report for occupancy based on room rate classification. We have three rate classifications, depending on long-term, short-term, or Penthouse: Tenant, Transient, or Penthouse. The first two may occupy the type of room, but the third is only in the condos. The "Building...

Watch MrExcel Video

This Week's Hot Topics

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top