Search results

  1. H

    User-Defined Type Error Message

    Hi all, I have the following table in which orders are stored by each product type in a row. However, I want to bring all product types in one cell 'field' in a query by each product type as shown in the following snapshot. To achieve this, I copied over the following ADO function in a...
  2. H

    Solved Compile Error: Expected user-defined type, not project

    Hi experts, I want to copy data from one table into another using the following code. Before copy, this codes runs through the objective field and looks for comma (,), when found it splits the word before a comma into a new row in the destination table. However, when I click on the button to run...
  3. H

    Split Data By Comma Delimited

    Hi Experts, In Table_A I have the following fields. ProjectName Sectors Tags Data in the Tags field is delimited by commas (,) such as the following: ProjectName Sectors Tags Water Supply Health Clean Water, Hygiene, Human Rights, Access to...
  4. H

    Split Data By Each Comma

    Hi Experts, I have fields [DateEntered] and [Objective] in Table1 as following. Table1 DateEntered Objective 1/2/2016 Objective 1, Objective 2, Objective 3 I need to automatically split data in the [objective] field by each comma (,). The resultant table (assume Table2) should...
Top Bottom