relationship

HI, recently could not get the relationship form date to fact table in the right direction , i had several tables with date columns and had created a calendar, but the direction was always wrong, so I then tried joining to one of the other tables this worked fine, so I deleted from data...

when creating a relationship between two pivot tables it complains both columns contain duplicate values. at least one of the columns selected must contain only unique values to create a relation between the tables both my tables contain a column called WellId (well name) with the same format...

Hi Guys, Pretty new to excel so hoping there's a simple answer to this that I'm not aware of. I work in marketing insight and part of my role is selecting the best customers to send each of our direct mail campaigns to, and I want to create a workbook in where I can walk through our monthly...

Hello, I am trying to attach several columns in one table to one column in another. Here on the "Accessory" table, we can have up to 3 devices, in the three columns. Device Type Device Type2 Device Type3 IPHONE 6S+ IPHONE 7+ IPHONE 8+ IPHONE 12 IPHONE 12PRO IPHONE 12 IPHONE 12PRO...

Hi, I need your help to find the relationship in these values. Hopefully this is the right place for it. So I'm trying to reverse engineer a formula and am stuck at the final hurdle. I'm determined to crack it. I've listed 10 numbers below (column A) and the associated figure that's returned...

Aloha In Access, I have a table with three parts Specialty Location List of support names In my form I want to have a field to enter number 1 and number 2 the result in a different cell will return the correct name. B The attached images is from my table. The first two are the condition that...

How can i get the relationship among this 4 variables a = no of days = 30 b = rates/number of holes/ma = 315.81 c = expected monthly target (number of holes) = 240 d = expected production amount = 75,795.36 (Naira) regards

What is the best way to count how many time text appears in a cell? For example: 1a. Behavioral health issues;#19a. Relationship (spouse, failed intimate relationship, close friend, etc.);#21a. Substance Abuse (History of drug and/or alcohol abuse) Count how many times just "a." appears in a...

Hi, I have two tables, one data table and one lookup table. However, the lookup table doesn't seem to work for all values of the lookup table below: <tbody> 0 1-5 6-15 16-19 20-29 30-39 40-49 50-64 65-74 75-79 80-89 90-w </tbody> For lookup table value of 1-5 and...

Hello! How can I create a relationship graph of two variables please? For example: Variable Y1 Variable Y2 Variable Y3 Variable X1 23 52 53 Variable X2 52 24 36...

Is it possible to find the mathematical relationship between two cells? Or maybe various cells that contain variables and one cell that contains the output?

Hello all. I am new to Power Pivot and am taking my first stab at it by uploading multiple data sets that show net revenue received for each company. I am having a difficult time creating a relationship between the net revenue columns for each data set. Instead, I receive an error saying "Net...

Hi, I'm still learning access and I'm having some trouble with a database I am trying to make. Below is a photo of the relationships I generated for the proposed invoicing system called Direct Pay Voucher ("DPV"). Here is the set up: Many employees can generate a DPV (we want to track who...

Apologies in advance... i'm quite a rookie with Access. I have a table (tblCompanyInfo) with all of the information of different companys within. Within this table is a field where users can select a 'CompanyType' from a combo box. I'm looking to find a way to split the companys up into...

Hi everyone, I've come this far: Test.xlsx But I can't explode the subparts. Tricky part is SubPart2 also includes SubPart3. Well, it's 4 am here and I am like :banghead::banghead::banghead: I've tried every single relationship combination. Every Column and row combination but no way...

Hello, I have an issue and I desperately need your help. I have two tables with orders (a trasaction number is a unique value) and another table with sales invoices (several invoies can be issued to one transaction number). The tables are linked via transaction numer, however when I create a...

"Column 'Serial #' in Table '300 Machines' contains blank values and this is not allowed for columns on the one side of a many-to-one relationship or for columns that are used as the primary key of a table" This error is killing me and I have no idea how to fix it. The dumb thing about it... I...

Hello Id be really grateful if anyone is able to tell me how to solve the following in VBA: I need to extract (into two columns on a separate sheet ideally) the child and parent relationship from a table of data. The table data range varies between 5 and 10 columns, with the right most column...

Hello, I am just starting to learn about databases and MS Access. I have a question I have 6 tables tblBlanks, tblPowder, tblProcesses, tblTypes, tblColors, and tblProcessCategories tblTypes has a one to many relationship with tblBlanks through TypeID field. tblBlanks has a one to many...

I created a relationship in between two tables and tried to create a pivot table. When I added a field from the second table in the data model I received an error message saying that I needed to create a relationship between the two tables though one existing when I open the relationships...