Help with a query!

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I'm an Access beginner! I have a database of market research participants,
and I want to run a query that will exclude all those who have taken part in
certain tests. One of the fields in the database contains the test numbers,
which are entered in this manner: T01-2. T04-4. T04-17. T05-23 etc. Now -
if I try to exclude anyone with "T04-17" in that field, I only exclude those
people who have this test # as their first entry. How do I write an
expression that will search for and exclude one or more test numbers that are
anywhere in that field?
THANK YOU to anyone that can help!
 
Your data structure is not following normalized relational database rules.
You only store one piece of data per field.

You need to revise your database and enter the tests in a separate table
with a one-to-many relationship to your main table.
 
Back
Top