Search results

Thanks for the reply.. I have tested the solution of MStef this is working wel! But I have now a new challege.. I have aroung 80.000 records in that same colum. Some of these has to be changed to "EDH01" and others to EDH02/03 and so on. How should I do this.. Should I work with If Else...

I am new here and dont know much about access but I have to do some things. I have a table filled in access. This table (dlb_tbl) contains serveral colums. One colum named "type". The records of this colum has to be changed like this: one record: 0RD00S101 this has to be changed into...