linking tables

  1. R

    Linking three tables in Power BI or Power Pivot

    I have a restaurant and want to find out my theoretical ingredient use based on my recipes. I have three tables, 1. MENU (pizza, lasagna) 2. RECIPES (8 ozs of ham per pizza) 3. CHECKS or INVOICES (for food served) 4. INGREDIENTS (ham, tomato, wine) To find out how much ingredients I used I...
  2. F

    Having trouble linking tables without pivot table (pivottable doesn't format the way I want)

    Hi,I am having trouble with excel 2013. I am currently working on a workbook for my school newspaper's business team. I have a revenues and expenses table, the expenses table links to a fundraising goal table so that everytime we spend money on an item, if that item is located on the goal table...
  3. M

    One Big Table??

    Hi all, I have 12 tables which I need to merge into one big one if that makes sense? Eg Employee Name Start Date Progress Report Out 2 Week 4 Week 6 Week 8 Week All tables are set out like this but are broken down into departments. I now need to create one big table with: Employee...
  4. J

    link form & subform for data entry

    I am trying create a form that has the main form as medbill containing vendor name, account number etc. I also have a subform medbilldetail that has invoice number, description, etc. There are two tables, medbill & medbilldetail; medbilldetail has a field medbillID, numeric long integer. The...
  5. D

    MSAccess limitations when linking to ODBC database

    My Office PC has Access 2002 installed (with Office Standard 2003). I'm connecting to a remote Mainframe containing hundreds of DBase2 tables, the structure of which I have no control. Whenever I link to the table I'm interested in, Access pulls through around 256 fields of which I need about...

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