Reply to thread

Message: [QUOTE="Clifford Bass, post: 13520039"] Hi, Sorry, forgot some issues :-( I was assuming that there was both a comma and a space. Which may not always be true. So adjust the formula to: Trim(Right([Comments],Len([Comments])-InStr(1,[Comments],","))) Also, there may be fields that do not contain any commas. With these you get something like Len("xxx") - InStr(1, "xxx", ","), which becomes 3. So it will return the all of the string. You will need to decide whether or not you want to include them. There also may be some blank fields that are Null. With those we end up with a Len(null) - InStr(1, Null, ","), which returns Null. The Right() function does not care for Null. So, in your query you will want to eliminate those that are null: where .... Comments Is Not Null .... If you want to eliminate anything without a comme use: where .... InStr(1, Comments, ",") > 0 .... Hope that helps, Clifford Bass [/QUOTE]