Using values in a table for criteria

[Board2Death]

I have a table that has the employee ID as a field. How do use all the employee ID's as critreia? For example the criteria would be something like "ID001" or "ID002" or "ID003" or ...

I do not want to type all 50 ID's for each query that I have to write. Can the query just use the values form the ID field in the table somehow?

 

[SkipVought]

Hi,

...
From MyTable1
Where EmployeeID in (Select EmployeeID From MyTable2)

Skip,

_{[red]Be advised:[/red]We know Newton's 3 Laws. But did you hear about the [red]FOURTH???[/red]
Only ONE fig per cookie!}

 

[Board2Death]

Not quite sure I follow this. Why do you have two tables?

 

[SkipVought]

Why would you use the same table?

Skip,

_{[red]Be advised:[/red]We know Newton's 3 Laws. But did you hear about the [red]FOURTH???[/red]
Only ONE fig per cookie!}

 

[PHV]

FROM MyTable1 INNER JOIN MyTable2 ON MyTable1.EmployeeID = MyTable2.EmployeeID

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886

 

[Board2Death]

I think that I may have either not posted a clear question...or maybe I just don't understand the replies. Let me try to explain better what I am doing.

I have a table (tblQualityStaff) with employeeID as a field. I guess this table qualifies as a lookup table since the only fields in the table are employeeName and employeeID.

I want to write a query that returns some data from a table called tblLots. tblLots contains a field called addedBy (which contains the employeeID of the person who created the record in tblLots).

I want to create a query the returns results from tblLots where the addedBy field is equal to one of the employeeID found in the tblQualityStaff.

If I am in over my head, I appologize for taking up your guys time. I do truely appreciate your efforts to help.

 

[PHV]

SELECT *
FROM tblLots INNER JOIN tblQualityStaff ON tblLots.addedBy = tblQualityStaff.employeeID;

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886

 

[Board2Death]

Thanks...Makes sense and works great.