Hi all, it has been a while since I delved into Access, but here I am.
I have a table that contains two columns (names and classes attended). In the Classes column, the entries are separated by commas, so it look like: 1st, 2nd, 3rd etc.
I am trying to run a query to show all in a specfic class, i.e. 51st. The problem I am encountering is that the like operator returns all classes that contains 51st, 151st etc.
I am looking for suggestions on a better course of action.
My thanks.
I have a table that contains two columns (names and classes attended). In the Classes column, the entries are separated by commas, so it look like: 1st, 2nd, 3rd etc.
I am trying to run a query to show all in a specfic class, i.e. 51st. The problem I am encountering is that the like operator returns all classes that contains 51st, 151st etc.
I am looking for suggestions on a better course of action.
My thanks.