Hello all. I’m trying to figure out a way to run some type of query against my Access Database in which I can count the number of time a distinct string shows up.
I tried
select count(ColumnName) from tableName where ColumnName like %string%
Apparently you can’t do that. Can anyone offer some suggestions as to how I may accomplish this? I only need it to return a number.
