5 Replies Latest reply: Nov 7, 2012 1:10 AM by sujeet singh RSS

    Seperate delimited data

    ahnet ceylan

      Hi everyone,

      In my access database, there is fiield showing employee's identiiy but it ıncludes more than one id with ";"

      such as 100;101

      İn qv side 100 id ' s name Alex but because of delimited data ı can not see the name of 100 ID

       

      ID                         Name

      100;101               ------

      100                         Alex

      101                          David

       

      How can I seperate the delimited field in two different rows to see names?