I have a field in my database that displays a list of numbers separated by a coma. Example "0, 1, 2" or "1, 3, 5, 6" . I want to create a calculated field that says if the original field contains a 1, then display the corresponding text description. The 1 could be in any location along the series. I've tried various combinations of Iif, Left, or Like, but these keep resulting in syntax errors. I'm looking for help to identify the proper function and related syntax.
Any suggestions are greatly appreciated.