September 13, 200619 yr HI I made a checkbox value list eg 1,2,3 After a number of records had been populated i realised I need to change the valuelist to 1a,1b,2,3 Is there anyway to delete the "1" from the records that are already entered? I obviously cant use the replace option as some records may have 1 and 2 entered and other 1 and 3 Edited September 13, 200619 yr by Guest
September 13, 200619 yr You might try: Replace ( checkbox ; Position ( checkbox ; "1" ; 1 ; 1 ) - 1 ; 2 ; "" )
Create an account or sign in to comment