Hi there.
I'm working with an Access database and need to be able to count the number of commas (or comma separated words) in a text field in the table [Survey Data]. The field has numerous comma separated words.
I've read a bit online that I could parse the field into multiple fields, or could possibly use CountCSWords to count the number of comma separated words. I don't see the CountCSWords function in the Expression Builder though. I'm pretty new (actually, very new) to Access though and have no idea how to do this. Is there a way that I can have this as an expression in a calculated field in a table or query? I'd really appreciate any help y'all can give me so I can get this t work.
Bookmarks