Help needed with constructing query

[Appletreeman]

HI all,
I have a question about how to construct a specific query...
(I'll try to include as much info as possible)

In my db I have a main table "main" with the following fields

• ID - primary key
• qa-op - number (related to 'qa-ops' table - list of peoples names & teams)
• job_num - number
• engineer - number (related to 'engineers' table - list of engineers names)
• valid - yes/no
• fail-reason - number (related to 'reason' table)
• fail-resolution - number (related to 'resolution' table)
• notes - short text

The qa-op field is related to a 'qa-ops' table with the following fields

• ID - Primary key
• name - short text
• Team - short text

What I would like the query to do is show a list of jobs where the associated qa-op is in a specific team. I have no idea at all how to go about this.

Any help at all would be greatfully received.

 

[pbaldy]

You should be able to add both tables to a query, with a join on the common field. That would let you add the team field to the grid and apply a criteria to it.

 

[marlan]

Here you can read about table joining: http://www.sqlcourse2.com/joins.html
And here about how you do it in Access: http://www.techonthenet.com/access/queries/joins1.php

serf these sites about SQL and Access, they are great!

ATB