Unanswered: Access query (Multiple values with comma separated)
I have problem in querying data when multiple values are stored with comma separated. Here is the illstration,
T1 has two column with Column1 and Values, Where Column2 contains multiple values with coma separated.
Normalize your schema. Repeating values in a row violate first normal form, whether they are semicolon separate lists in a single column or columns like: c1, c2, c3. etc. Once you fix the schema, you'll be able to query using standard SQL... Using what you've got, you'll have to resort to all kinds of trickery to get a working query.