Help with a query!

P

Pizza

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!
 
R

Rick B

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

update hyperlink values but not displayed text 1
NOT expression in a Query 3
Query critieria to exclude 2 words 2
Excluding some info. in a Query-Access 2003 4
Trying to create a report that will list unmatched records by Ticket Primary Key 0
Help to select record by checking multiple child items 2
Update Query Question/Problem 1
Conditional Find Duplicates Query Help 1

Top