join

  1. 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...
  2. 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?
  3. 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...
  4. 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...
  5. 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...
  6. 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 ?
  7. 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")))...
  8. 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...
  9. 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."...
  10. 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...
  11. 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...
  12. 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...
  13. 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...
  14. 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...
  15. 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"...
  16. 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)...
  17. 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>...
  18. 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)...
  19. R

    Consolidating columns plus lookup and return multiple values?

    Hi all, I'm looking to find a solution for joining (sorting and removing duplicates) multiple columns in one cell and then lookup all values in a separate table and return potential values in another cell. It would look something like this: <colgroup><col span="4"><col><col></colgroup><tbody>...
  20. R

    VBA: Combobox ID Value as Query Parameter not longer working

    Hi experts, I have a VBA code that opens a recordset: Private Sub Form_Load() Dim qdfFillDictionaryOptional As DAO.QueryDef Dim rsFillDictionaryOptional As DAO.Recordset Set qdfFillDictionaryOptional = CurrentDb.QueryDefs("qryFillDictionaryOptional") Set...

Some videos you may like

This Week's Hot Topics

  • Problem with Radio Button's format control
    I am creating an employee evaluation template (a sample is below) Column A is the category Column B, C D, E and F will be ratings (unacceptable...
  • Last Display on userform to a Listbox
    [CODE=vba] lstdisplay.ColumnCount = 15 lstdisplay.RowSource = "A1:O600000" [/CODE] So when i do this it Displays everything on the sheet i am...
  • Rename and move files to a new location
    Dear all, I have an excel file with the following information. The actual file name is at column A but i want to rename it using the following...
  • Help with True/False Formula
    Hello! Am stumped how to fix this formula, in which my result returns 'True', but it should return False. =IF(AG2=True...
  • Clear extra characters from a provided range of cells
    Dear All, I have following code which gives me desired output to remove extra characters from a provided range. But it takes too much time when...
  • Help with Current and highest streaks
    Hi there, I've just joined the forum and this is my first post. I've already spent quite a bit of time searching the net and this forum for a...
Top