Here Election is your column name in which you have entries like "GE12GE11PE10GE09GE08GE06PE06GE04GE02GE00GE98G E97"Code:SELECT [Voters] FROM [Table] WHERE inStr(1,[Election],"GE12") > 0 AND inStr(1,[Election],"GE11") > 0
To exclude, you can just change or add conditions in the above given query.
e.g. instr(1,[Election],"PE10 ") = 0
Bookmarks