Records Meeting Two Criteria

  • Thread starter Thread starter K. Bryan
  • Start date Start date
K

K. Bryan

I feel so dumb that I don't know the answer to this one, so if anyone out
there can help put me out of my misery...

I've got two tables, with a master/child relationship.

In the child, there's a field called "Talent_Type_ID".

Of course some people have multiple talents, so there is more than one
record for them.

Now, imagine that I wanted to return all the master records that had a
"Talent_Type_ID" of both 1 & 3.

Right now, I can pull back all the ones that have 1's and all the ones that
have 3's but can't figure out how to just pull back master records that meet
BOTH criteria.

Any suggestions on how to write that SQL statement?

All help will be GREATLY appreciated.

_K
 
Make a new query (in design view) and add your "master" table and the
"child" table twice. Get your output fields down to the grid, and also the
Talent_Type_ID field from both copies of the "child" table, and add one
criterion under each on the same line. This should do the trick.

HTH,
Nikos
 

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

In a query, show master records even if a child record doesn't exi 2
Access Query to show records that do NOT meet join criteria 1
Show Duplicate records only once 3
VBA: How can I use a string variable as autofilter criteria? 4
Parameter query to select multiple child records on the same field 2
count of records that meet criteria from two fields 1
Selectively Update Field in Table 2
specifying multiple "not like" criteria 6

Back
Top