About 5 months ago, I posted a mini-article entiteled "Improving the InStr Function". Here is the link to that article (which I also posted to some Excel groups as well)... https://lnkd.in/eCAnVKXR ...
Utilizing the Access InStr function: Aggregating values when a single field contains multiple values
When you want to aggregate values in a table where a single field contains multiple values, you can use the InStr function in a select query to separate them, and then perform aggregation using an ...
Some results have been hidden because they may be inaccessible to you
Show inaccessible results