join

  1. T

    Need formula that joins field in one table to field in another table

    Windows 10 Pro, Office 365 My question: I have a field in table A that I want to join to table B and place in a new table C. I cannot figure out the formula to do this. Table A contains two fields: Store_Number and Group_Name. Table B contains four fields: Group_Name, Item_Number, Item...
  2. Johnny Thunder

    VBA Help - Build Formula based on Variable Count

    Hello All, I am working on a project that has several macros but there is one piece of the puzzle I am unable to completed. I will do my best to explain what I need visually. I have a loop that looks at a sheet (Timing Assumptions) and based on a row called Percentages, the user is able to...
  3. M

    Join all row cells in a single cell by vertical bar

    Hello,</SPAN></SPAN> I need to Join P:Y column each row cells in single cell by using a vertical bar, result require in AA column as shown below </SPAN></SPAN> Example</SPAN></SPAN> <b></b><table cellpadding="2.5px" rules="all" style=";background-color: #FFFFFF;border: 1px...
  4. L

    join a list of date

    I want to join a list of date together quickly. the join function requires the text function for every single date. Is there an easier way to join a list of date together?
  5. R

    Using SQL in VBA LEFT JOIN to fetch data from multiple sheet

    Hi Expert, I have three sheets of data using LEFT JOIN i am supposed to pull the required columns as result. This is the main motive. With the help of this link https://analystcave.com/excel-using-...on-excel-data/ i took the code which does connection to my excel sheets. I need an experts...
  6. B

    Microsoft Access cannot find the referenced form 'frmTagPrintEquip'

    I am running SQL statement but get the title error. The form is a lookup combo box that is closed until a cmd button opens it. strSQL = "SELECT tblTag.TagNumber, tblTag.TagID, tblEquipment.Equipment, tblEquipment.EquipID, tblTurnaround.TurnaroundID " & vbCrLf & _ "FROM...
  7. D

    Trying to average last 3 records only (top 3)

    So I'm trying to create a query that will produce an average (totals) column based on the TOP 3 records associated with two other key field values. Basically an average of the three most recent events. I can easily create the query to do the OVERALL averages, but whenever I try to use the...
  8. M

    How to use a field as "Not Something" to be condition of a query

    I have a table with one column storing the condition of a query, like "*" etc. * means all countries Now, apart from "*", there is a need to have a condition "Not US" So, can we join table has same effect as "[Country] is not US" ? What can I do ?
  9. A

    Joining two IF/ AND statements

    I am trying to join two statements but keep getting errors. Please could someone help me and explain how to join them into one statement? Both Statements work correctly on their own =IF(AND(A12>=$K$3,A12<=$L$3),"Sunday",(TEXT(A12,"dddd")))...
  10. A

    Join between tables

    Hello, Regarding the binding of tables in Power BI, I would like to know how to make this connection, in the habitiude in SQL, we do the join or the connection between the tables with a primary key, but in Power BI I noted that There are linked tables with other fields. For example in this...
  11. A

    Subquery To Select Checks by Varying Age Requirements

    Hi all, I have a need to select all checks that fall within an age threshold determined by a client's preference. For example, one client might choose a 30 day threshold, another might choose every ninety days. I am receiving an error: "at most one record can be returned by this subquery."...
  12. R

    Zero (0) values not showing in query result

    I have made a query based on comoboxes and checkboxes. One of the checkboxes is chkExternal. When it's checked I want all the scores from all employees to appear: Internal + External Employees, or 0 en -1 values. When it's not checked I want only 0 values to appear: only Internal. This is the...
  13. K

    JOIN an Access table and a SQL Server table in a single query from Excel VBA

    H, I am using Excel 64-bit I have a ms-access database and in this database I have normal ms-access table and some linked table from SQL Server, I have a query that is taking a reference of a linked table, and when I am firing that query from excel vba it is giving me an ODBC connection...
  14. L

    Find decimal-formatted and replace with % in a text cell? Maybe RegEx?

    Hello! I have been working on a report, manipulating and formatting various features using VBA. I received a request I haven't heard before. The exported file contains several columns that contain percentage-formatted values of three or four digits. I'm being asked to join those with text from...
  15. X

    data type mismatch in criteria expression - Don't understand my problem

    Hi and thank you for considering my problem... I am receiving from Access an error message....data type mismatch in criteria expression The crazy thing is that I have run this before and not had a problem. I am trying to make a make table query for a union situation. I have three queries I...
  16. L

    Excel 2007 Query Join Multiple Table & Show All Records From First Table

    Hi, I've generated a query with 4 tables which consists of 1 main table & 3 other tables that join to the main table. I've joined all 3 tables to the main table & it works fine except for if 1 of the records from the other 3 tables is blank, then it doesn't show the record from the main...
  17. K

    Join multiple cells into single cell with VBA

    Using Excel 2000</SPAN></SPAN> Hi,</SPAN></SPAN> I want to join multiple cells C:P columns, into single column R for that using formula getting the result as below</SPAN></SPAN> Getting result using formula...</SPAN></SPAN> <b></b><table cellpadding="2.5px" rules="all"...
  18. M

    Split array and re join

    I have an array that I am able to split and get the individual text in it, then I take each string and find match on another sheet and grab the Id in the next column. I want to take the ID that I find and re join into an array. v1 = Split(ws1.Cells(r, 7), ",")For i = 0 To UBound(v1)...
  19. K

    Why not row is summing after the separating join text

    Using Excel 2000</SPAN></SPAN> Hi,</SPAN></SPAN> I got 2 columns B & C in these columns there is a join text I want separate them in columns E, F, G, H for that I am using the formula below the problem is that if i want to sum rows E:H why I am getting 0? Please need help</SPAN></SPAN>...
  20. M

    Using the First or Min function.

    I have a table with all my Customer Orders and I'm trying to return a single record for the Earliest OrderPlaced but I cannot for the life of me return the single oldest Order Number according to the CustomerID. I have 2 tables: CustomerOrders Customers OrderNumber (pk) CustomerID (pk)...

Some videos you may like

This Week's Hot Topics

  • Copy entire row if CountA <>0 to another sheet
    [B]I want to copy entire row if CountA <>0 for column J7:AM7 (headers on J6:AM6) and so on till the last used cell is column D and paste the...
  • Select last used Row in Table
    I have created a Table in a Worksheet which is locked to prevent user errors and protect formula. Some of the cells require freetext entries which...
  • excel workbook: do not allow certain file name
    Hello all, Don't think this has ever been asked before, but how do I restrict file save [Before_Save Event] if the name of the file being saved...
  • fixing problem autofilter
    hello i need help about my code when i search by code in textbox it doesn't show anything this is my data [ATTACH type="full"...
  • “Weight”
    Hi, i’ve got a long sheet filled with weights such as kg,g,L & ml. i can build a formula to convert kg into g and liter into ml. How ever, my...
  • How to capitalize everything before a certain character?
    In column A, I have some text: Hello good day.mp3 Hello good day.flac etc. I'd like to capitalize everything before the period. I don't need the...
Top