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
 
Back
Top