join

I thought that I understand the differences between the 3 different. Join 1: Only include rows where the joined fields from both tables are equal. Question: Does this mean that it is only going to display the records where the join field in both tables are equal? (is this an inner or outer...

Hi I have the following VBA code against sheet 1 and this is working on a single column D4:D100. But now i need to track the date a change to any cell within 4 different columns independently, I can not get this to work. Can anyone help please? I assume I have joined / linked the code...

So below is my SQL query, but when I add the client.name it pulls every client in the system instead of just the one that has the one account i'm searching for in it. Is there a way to join one table to another to show me just the client's name on that one account? Select DCGI.Client...

hi all, how to join to next cell(row) i am on A1 if i press F4 (this copy the lastformat) my question is: if i press F4 how to go to A2, if again press F4 join to A3 and so on. how to configure Excel? thanks....

Hi, I was wondering if something was possible within Access queries. I wanted to join a field with one table to two possible fields in another table. Essentially the value in field "A" in Table1 could be found in field "A" or "B" in Table2. Table 1 has my list of unique values that I want to...

Hi everybody, first of all, sorry for my english! I have this scenario: Office 2016, connecting to a Oracle Database 11g, and running this query: WITH tbl AS (SELECT c.codchamado AS chamado, c.strtitulo AS titulo, t.strtipo AS...

I'm hoping someone out here can help me, or at least confirm that this is an issue. I have two queries based on the same table. Both use Excel.CurrentWorkbook(){[Name="Data"]}[Content] to call the source. The table contains records of interactions with clients, and there can be more than one...

Hi all, I'm working on a db I inherited, and I'm troubleshooting a query that returns duplicate values. The problem is a table that either generates a timestamp, or the timestamp is passed from VBA during some other query, BUT the timestamp is invalid, inconsistent, and changes frequently...

Select MLB8.PROG_REPORT_ACCT_NUM_AND_PRACCT, DCGI.Date_Listed, DB.INITIAL_BALANCE, DS.Last_Payment, LV.Amt_Paid_On_Acct, DB.Principal_Balance, MLB7.INVENT_INVEN2 From Clnt_General CG Inner Join Dbtr_Clnt_Generl_Inf DCGI on CG.Client_Num1=DCGI.Client Inner Join Dbtr_Status DS on...

I want to Join two cell with "&" A1=13 and B1="Name" . when Join these two ,i want "Name" show Bold letter.

Hello everyone! I have a query in access (I did not build and has worked for 13 years) that all of a sudden is not working anymore and gives the "Your SQL query could not be executed because it contains ambiguous outer joins". I'm not very adept at SQL so I am struggling on fixing the issue...

is it possible in excel 2013 to have a chart with 2 value axis, 1vertical and 1 horizontal, to allow to plot points as coordinates and then join up as a line. hope that makes sense, thanks

Hello everyone! I am trying to figure out how to get an SQL string correct and need some assistance. I have a table of data that is comprised of approximately 30 excel files. Field1 and Field2 are indicator codes that when combined (Field1.Field2) indicate a department. The department for...

I would like to join and merge the cells in column B using the "merged rnages" in column A On top of that the same for column c. I used the solution from jim may but run into trouble. " Re: How to Find the Next non-empty cell using vba excel (plus merge it) Sample Table BEFORE...

Hi All, I am not a super-star SQL writer or database programmer, so I am trying to figure out how to do something in Access. I have two tables. Quarter 1 and Quarter 2. They both contain the same number and type of fields. I would like a query that does the following: Return the data from...

I am trying to assign a unique number to each row composed of 4 data elements provided via input box and a portion of an existing value in a related cell. I have tried a couple of different options and keep hitting a wall. The string below is long but I hit a snag towards the bottom in green...

I am currently using this formula to retrieve and combine multiple cell data into one cell and make them comma separated JOIN(",",TRANSPOSE(B3:B69)) But is it possible to do the same but only retrieve cell data in column B is the corresponding A column cell equals certain criteria (example =...

Hi there! I wish everyone has a very happy new year and my special wishes to Mr.Excel staff for supporting us! I would be grateful, if you could help me on the problem below: Imagine that on week 1 i have a new table like this below : <tbody> A B C D A 2 4 1 B 1 2 6 C...

Here is my table and my error (Highlited). How come my join is doing this? If there are multiple lines then the calculation doesn't work. <tbody> ID Line CUR Amount Amount US (CALCULATION) FX Rate 1 A GPD 100 150 1.5 2 A GPD 100 150 1.5 2 B GPD 500 0:crash: 1.5...

I regularly run queries inside excel VBA. What I do is I store the SQL code in a String variable 'sqlStr', and then I use that string and pass it to a function which runs SQL Code by opening a connection with ADODB, connecting to a 'serverName' and 'databaseName'... there are hundreds of...