Search results

  1. B

    How to create a temp table from concatenated fields that vary in length

    Thanks for the function. I copied it to my functions module. But then I am lost. I tried to create a query using it and received #error in the field. Here's the query: MyField1: fnSplit(1,[Customer],"/") Ben
  2. B

    How to create a temp table from concatenated fields that vary in length

    I have a parts table. In it there are two fields that have string info (Customer and CPN). For instance: Parts Table Example: PartNo Customer CPN 1678 Yen/Stick/Pearson Yen: 2321*Stick: 52344J/45*Pearson: Hy45 1679 Carson Cy8911 1680 1681 Harry's In the example...
Back
Top Bottom