Recent content by Vir77

  1. V

    How you find duplicates but only just for the first 12 characters in a cell?

    Thank you. I understand what you're saying. To separate the first 12 characters in a separated field/column (which also can be done in the excel-sourcefile) will also solve the problem. Then it will be easy with the Query wizard.
  2. V

    How you find duplicates but only just for the first 12 characters in a cell?

    Yess! This solution works! Thank you so much!
  3. V

    How you find duplicates but only just for the first 12 characters in a cell?

    Yess! This solution works! Thank you so much!
  4. V

    How you find duplicates but only just for the first 12 characters in a cell?

    Hi people, I want to make a query where I can find duplicate cells. But the query must not check the complete cell. Just the first 12 characters in the cells must be checked on duplicate values. Below you can see my tabel. For example: NL_1102CW_150___AMSTERDAM NL_1102CW_150___AMSTERDAM...
  5. V

    Hello

    Hello Accessworld
See more
Top Bottom